General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Markus,
I agree entirely - I was more looking to learn if perhaps you had found that there was no such a thing as 'partially optimized' even though the docs suggest there is. Seems the docs are correct here (phew!!!!).
Thanks,
Jim N
>>So when does the 'partially optimized' mentioned in the docs take effect, and what does it really mean????
>
>Well, to be honest, Rushmore isn't turned off entirely. It's switched into 'partially optimized' mode. But IMHO, 'partially optimized' isn't good enough if all that's missing for 'full optimization' is the index on Deleted().
>
>Here's an example:
>
>Use the customer.dbf in the VFP sample data directory. Note that there isn't an index on deleted. Now issue the following commands:
>
>SET DELETED ON
>SYS(3054,1) && VFP will notify us about the optimization level
>SELECT * FROM Customer WHERE Company = "B"
>
>VFP will tell you that this was partially optimized (whether or not you have deleted records doesn't matter at this point).
>Now, try adding an index on deleted and do the same exact thing again. VFP will now tell you that the SELECT was fully optimized.
>
>Markus
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only