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?
Tracy Pearson wrote: > Are they requesting the data like the index was created? The expressions > structure needs to match the index. That causes some grief with non-rushmore > instructed individuals. > > > -----Original Message----- > From: MB Software Solutions, LLC > Sent: Tuesday, November 10, 2009 1:19 PM > > Our vendor is having performance issues in their accessing our foxpro data > over OLE-DB. If indexes are present, they are used, right? They claimed to > have used something like a sniffer to see what looks like a table-scan to > them (meaning that indexes are NOT being utilized). > > tia, > --Mike > > -- > Mike Babcock, MCP > MB Software Solutions, LLC > President, Chief Software Architect > http://mbsoftwaresolutions.com > http://fabmate.com > http://twitter.com/mbabcock16 > > [excessive quoting removed by server] _______________________________________________ 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.
