SQL Server Query Tuning Series - Cluster Index Seek and Index Seek
SQL Server Query Tuning Series - Cluster Index Seek and Index Seek #jbswiki #querytuning
Restoring Required Databases for Query Tuning Session - • Video
DROP TABLE TABLE7
create table Table7(
col1 int primary key identity(1,1),
col2 int,
col3 int,
col4 varchar(max),
col5 varchar(max))
insert into Table7 values (1,1,replicate('a',900000),replicate('a',900000))
go 1000
set statistics io on
select col1,col2,col3 from Table7 where col1 between 1 and 999
create index ix_test on Table7(col1) include (col2,col3)
select col1,col2,col3 from Table7 where col1 between 1 and 999
set statistics io off
DROP TABLE TABLE7
Disclaimer:
The views expressed on this Video are mine alone and do not reflect the views of my company or anyone else. All postings on this Video are provided “AS IS” with no warranties, and confers no rights.
