home bbs files messages ]

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