Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index should be fully optmized
Message
From
04/11/2006 15:58:09
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index should be fully optmized
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01167140
Message ID:
01167140
Views:
55
I have a table with 360000 records. One of the field is Integer with a tag. If I do:
COUNT FOR NoInsuranc=0 TO lnCount
Isn't this suppose to be fully optimizable?

Because, this is not the case presently. I see the counter starting to count as if this wouldn't be. What could cause this reaction?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform