Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why table scan?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01293823
Message ID:
01294285
Views:
31
>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform