costs something to maintain the index, too. (Time to look for a book on SQL
that talks about such things...)
- Original Message -
From: Jacque Scott
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 6:28 PM
Subject: Re: More Left Join problems
Jacque Scott
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 2:18 PM
Subject: Re: More Left Join problems
Thanks for your time. I didn't think of formatting the query. Here is
the query in a more readable format. I have also taken out most of the
columns in the SEL
are testing
aren't available for the where clause to use.
- Original Message -
From: Jacque Scott
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 2:18 PM
Subject: Re: More Left Join problems
Thanks for your time. I didn't think of format
Thanks for your time. I didn't think of formatting the query. Here is
the query in a more readable format. I have also taken out most of the
columns in the SELECT. The query still takes 44 seconds.
SELECT Products.NSIPartNumber, If(Bom.ProductID Is Not Null,"x","") AS
BOM, Products.Obsolete
