Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexes: how is it used in SQL SELECTs?
Message
From
20/12/2001 12:05:26
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00596834
Message ID:
00596844
Views:
20
You're right...my bad

>
>Actually, the ORDER BY clause operates on the result set, so the existance of a tag on LastName in the original table isn't a help - a temporary index must be created against the resultset, which becomes disconnected from the original table unless it can be processed as a filtered view, in which case, there will be a noticable delay in navigating the resultant cursor.
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform