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 _______________________________________________ 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/000801ca6235$90b54cf0$b21fe6...@com ** 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.
