From: liz@paradoxcommunity.com   
      
   Jason,   
      
   First, please be aware that most people here use Paradox the application   
   to access Paradox the table format and so may not know the answer to your   
   question.  You might have better luck on forums for the application you're   
   using.   
      
   That said, I don't know whether there's any BDE command or option that forces   
   use of an index, but how long does it take to run a "select * from table"   
   query?   
      
   If you're running over a connection that's less than 100Mb, that could explain   
   the speed issue.   
      
   Am I correct that startdate is not a date type field in Paradox (or a datetime   
   type field)?  Cuz if it is, I can't believe it's going to like your date   
   criteria, in which case, it would return no rows and that's the slowest kind   
   of query.   
      
   FWIW,   
      
   Liz   
      
      
   "Jason"  wrote:   
   >   
   >I have a composite index on 3 columns (Classification, ClientID, StartDate)   
   >the index name is ByClientId.   
   >   
   >I have an odbc connection to the paradox 5 db via a DSN. When I run the   
   following   
   >query, it takes about 90 secs to return. There are 60K records in the table   
   >   
   >select *   
   >from table   
   >where classification = 1   
   >and clientid = 110   
   >and startdate = 39951   
   >   
   >It appears that my query is not using the index. Is there a trick or something   
   >I am missing?   
   >   
   >   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)