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
Previous
Next
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