Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement