Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
In the help file it specifies that GO BOTTOM uses an index, I would think that they all do.
BOTTOM
Positions the record pointer on the last record in the table. If the table has an ascending index in use, the last record is the record with the highest key value. If the index is in descending order, the last record is the record with the lowest key value.
>Hello all.
>My co-worker and I have a bet that we would like for you all to help settle.
>
>When "Go MyRecordNo" is issued, is there an internal index at work to find the record?
>
>Thanks.
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