Definitions
Sorry, no definitions found. Check out and contribute to the discussion of this word!
Etymologies
Sorry, no etymologies found.
Support
Help support Wordnik (and make this page ad-free) by adopting the word non-clustered.
Examples
-
By doing this, the size of the non-clustered covering index using the INCLUDE clause is smaller than the pre-2005 way of creating covering index.
-
To create a covering index all three of these columns will need to be included in the non-clustered index.
-
If a query were going to be run frequently and fast execution time was critical, then it would be appropriate to create a non-clustered index to help the query along.
-
By identifying the non-searchable columns in the INCLUDE column they will only be included in the leaf pages of a non-clustered index.
-
In developing the tests for this article, I made the interesting discovery that (in my laptop environment) the above non-clustered index performed better for these particular queries than a "covering" index which contained all columns necessary to satisfy the queries.
-
An obvious non-clustered index for our three examples would be one based simply on product id and date (descending).
-
The script will also create a non-clustered covering index (ix_Employees) on the employee table on the ManagerID column to eliminate any Key Lookups.
-
This document contains steps that will assist you in the completion of and review of a installation of a non-clustered SQL Server 2008 RTM Enterprise Edition software Instance.
Simple Talk rss feed Buck Woody 2010
-
Typically you will see a predictable ordering, but it might not be the one you expect (for example, it may happen to use a non-clustered index to sort).
SQLblog.com - The SQL Server blog spot on the web AaronBertrand 2010
-
Whereas the second SELECT statement, which is run after creating two non-clustered indexes, requires only 17 logical reads to resolve this query.
Comments
Log in or sign up to get involved in the conversation. It's quick and easy.