Pages

Monday, September 9, 2013

SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index | Journey to SQL Authority with Pinal Dave

Today I came across very interesting observation while I was working on query optimization. Let us run the example first. Make sure to to enable Execution Plan (Using CTRL + M) before running comparison queries. USE [AdventureWorks] GO /* */ CREATE TABLE [dbo].[MyTable]( [ID] [int] NOT NULL, [First] [nchar](10) NULL, [Second] [nchar](10) NULL ) ON [PRIMARY] GO /* Create Sample Table */ INSERT INTO [AdventureWorks].[dbo].[MyTable] ([ID],[First],[Second]) SELECT 1,'First1','Second1'… Continue Reading...

Source: SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index | Journey to SQL Authority with Pinal Dave