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

Reply via email to