Tagged Questions
4
votes
1answer
290 views
Storage order vs Result order
This is a spin-off question from Sort order specified in primary key, yet sorting is executed on SELECT.
@Catcall says this on the subject of storage order (clustered index) and the output order
...
3
votes
1answer
513 views
Clustered Index Update on Nonclustered Columns
Using: SQL Server 2008 R2
I am currently stepping through a query execution plan, and have come across an instance of a clustered index update on a table. The issue here is that the columns that are ...
2
votes
2answers
678 views
Why is query using Clustered Index when it shouldn't?
Let us presume I have a table named Category in a SQL Server 2005 database. Category has category_id (bigint, identity) as its primary key and name (nvarchar(50)). There is obviously a clustered ...
2
votes
2answers
408 views
Clustered monotonically increased index insert performance
I have a table with field Id (bigint, IDENTITY) as primary key and clustered index on it.
I inserted 400 rows and saw execution plan. I got: the relative query cost for this insertion 36% and for this ...
