Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complex Index expression
Message
 
 
To
05/11/2008 15:40:01
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01359216
Message ID:
01360027
Views:
26
>>>May I ask WHY you need such an index tag? If you have index tags on the relevant fields, a SQL Select statement is normally instant, and most likely gives you exactly what you really want.
>>
>>I think INDEXES have no bearance on the ORDER BY clause.
>
>Except on speed - if your SQL uses Order By something you have a tag on, Fox uses that to speed up the ordering - or else it would have to build a temporary index or use some other means of ordering the records. So having a tag helps.

Hi Dragan,

Before your reply I was 100% sure that indexes are not used in GROUP BY and ORDER BY by Rushmore. Now I'm only 99.99999% sure. Could you please verify?

Thanks again.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform