Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple VFP query, no optimization
Message
From
10/11/2000 17:26:57
 
 
To
10/11/2000 17:13:00
Jonathan Cochran
Alion Science and Technology
Maryland, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00440476
Message ID:
00440540
Views:
12
>If the original index wasn't filtered, you should have been able to use it for optimization rather than creating two new indexes on your table. Oh, well, at least you have it working now.
>

I would rather not have to add the 2 additional indexes. I have INDEXSEEK elsewhere on the the index key I already had, so now I have 3 indexes doing the duty of one. Original index expression is simple: custID + poNum. No filter. Should I not need individual indexes?
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform