Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting the Index Order on a View
Message
 
To
16/07/2000 16:15:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00393036
Message ID:
00393086
Views:
21
Since some of my views have a largish number of records I often load the view with NO records, set the index and then requery() with the new parameters. I've found this seems to be faster (no actual benchmarks) than running the view and reindexing.

INDEX ON expn TAG TagName
>
>Thanks Evan. I put the INDEX ON expression in the init event. Forsee any problems with that?
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform