1. Because the index is "unique", ie not all records are indexed. If a index doesn't include all records, it cannot be used in Rushmore optimization. There are 2 types of such indexes: filtered and unique.
2. Because in subsequent queries data is already extracted.
Vlad
>Hi, I have two queries regarding Rushmore:
>
>1)If I have an index of type "unique" the SQL/ODBC will not use Rushmore. Why??
>This was observed using SYS(3054,1) and the SELECT command in VFP 5.0.
>
>2)On the first connection to a web server using an "active" page with SQL/ODBC, the response is terrible but subsequent responses are very reasonable. Why??
>
>Thanks in advance.
>Petras
Précédent
Suivant
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