Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up SQL remote view ?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00572419
Message ID:
00574633
Views:
66
<<
>So you are saying that a pointer to the index node is faster than a pointer to the physical location of the row in the table? I'll but that.
>>

This is why, I believe, the query optimizer greatly favors a clustered index. It may seem superfluous, but if the information is not where the optimizer is looking, the optimization process will not work...
Previous
Reply
Map
View

Click here to load this message in the networking platform