Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.paradox    |    To crash or not to crash, asks Borland    |    9,834 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 9,753 of 9,834    |
|    Jason to All    |
|    paradox sql select w/index    |
|    19 Jun 09 09:14:44    |
      From: jason@sipstorm.com              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)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca