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,758 of 9,834    |
|    Liz McGuire to Jason    |
|    Re: paradox sql select w/index    |
|    19 Jun 09 14:34:11    |
      From: liz@paradoxcommunity.com              I can only refer to Larry's suggestions. But if having three indexes,       one per column, does the trick, I'd say go that way. Sounds like the       ODBC driver won't use the composite...              Liz                     Jason wrote:       > select * from table returns in 0.05 seconds, so it is very fast.       >       > All 3 columns are longs and data does return.       >       > If I create specific indexes on each column the query returns fast.       >       > Is there a problem with composite indexes?       >       >              --- 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