Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2000
>>How would you explain the fact I got 2 Index seeks with your test code and my addition of populating tables?
>>
>>>No, no matter if PRIMARY KEY index is CLUSTERED or not in both cases I have INDEX SEEK.
>>>Thanks again Walter.
>
>I can't. :-)
>I even can not explain why my friend has INDEX SEEK directly w/o running any code to populate data.
FWIW, it runs two index seeks for me as well. However with no records in there the execution time does not differ.
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