Stephen Russell wrote: > On Tue, Nov 10, 2009 at 1:14 PM, MB Software Solutions, LLC > <[email protected]> wrote: >> Yes, I've requested the query text from them to ensure that it's an >> exact match, but OLE-DB access *will* use use the index for optimization >> if a good match, correct? > ----------------------------------------- > > OLE-DB can only use a single index to do the workload. > > So if your index is correct for the join condition that is the INDEX > the table will use. If your Where clause has other columns in it like > InvoiceDate and that column is not part of the index used for the JOIN > the SQL Engine will default to a table scan to find the data you > requested from the table you wanted.
Steve, That sounds like rubbish. Sorry, but I'm not sure if I can trust that advice, given that you've been out of the Fox game for awhile. I appreciate the thoughts mind you, but that one is not one I'm going to bet on quickly without proof. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
