From: nospam@nospam   
      
   Jason wrote:   
      
   > It appears that my query is not using the index. Is there a trick or   
   > something I am missing?   
      
   I believe the query optimization is up to the ODBC driver.  Only suggestion   
   I can offer are to rearrange the where clause to order the criteria   
   differently.  One other possibility is that your ODBC driver was not   
   designed to use Paradox indexes in queries.  ISTR this was a failing of some   
   ODBC drivers.   
      
   You can also try rebuilding the index - it may be out of date, crosslinked,   
   etc, which would result in a performance problem.   
      
   --   
   Larry DiGiovanni   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)