about 5% of b are null.. any idea on how to word a query like what I'm looking for? I have no idea in SQL how to use the results of one select in another (I usually just do all of it in perl).
Travis -----Original Message----- From: Jeffrey Melloy [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:44 AM To: Williams, Travis L, NEO Cc: Thomas A. Lowery; [EMAIL PROTECTED] Subject: Re: [GENERAL] Join question On Friday, August 29, 2003, at 12:36 AM, Williams, Travis L, NEO wrote: > Performace wise would I be better off just doing 2 query's.. i.e. > select > a,b from table1.. then in perl I can check if b is not null and if is > isn't then I do a second query? > > Travis > I would say it depends on the table distribution (% of b that are null, etc). At that point, you're just going to have to experiment, I think, and see what works best for you. My gut says that even including a subselect, it will be faster than checking in perl and issuing another query. But I have no idea, and the proper solution might change drastically based on your data. Jeff ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly