Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed query with rushmore index
Message
 
To
09/03/2007 14:46:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 5
Miscellaneous
Thread ID:
01202405
Message ID:
01202414
Views:
14
>>>
>>>You should have indexes on:
>>>'koers_hist_tot.dat_krs',
>>>'fondsen.fonds_cd',
>>>'koers_hist_tot.fonds_cd'
>>
>>But if I index on fondsen it would take some time, so what is the use of this?
>
>It's supposed to be done during database design, i.e. index already exists when you run query.

Oh I see, thanks.
Zakaria al Azhar
My blog on Actuaris.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform