Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimization of a JOIN
Message
From
04/03/2008 15:44:19
 
 
To
04/03/2008 14:50:17
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01298581
Message ID:
01298628
Views:
26
Walter,

>BTW, get rid off the deleted tag. It does not speed up your query (except in very specific circumstances). Full optimization does not mean that it is most optimal.

that used to be one of my standard first checks. It changed to making sure if the index was at least binary and then thinking on deleting<g>.
On the off chance that the deleted() index helps at least somewhere in the app the slight slurp of the pure bitmap of a binary index helps MUCH more than I had imagined after first readin about it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform