TableScan-
When there is no index in a table then if we search like below then it is Table Scan
Create table TestTable(id int ,Name varchar(100) , Salary int)
insert into TestTable values(2,'B',2000)
insert into TestTable values(1,'A',1000)
insert into TestTable values(3,'C',3000)
select * from TestTable where id=2
Or
select * from TestTable
Index Scan-
If there is any index whether it is clustered or non clustered index if we search like below then its called Index Scan-
Create table TestTable(id int primary key ,Name varchar(100) , Salary int)
insert into TestTable values(2,'B',2000)
insert into TestTable values(1,'A',1000)
insert into TestTable values(3,'C',3000)
select * from TestTable
index seek-
If we search with some condition having index then its called index seek
select * from TestTable where id=2
When there is no index in a table then if we search like below then it is Table Scan
Create table TestTable(id int ,Name varchar(100) , Salary int)
insert into TestTable values(2,'B',2000)
insert into TestTable values(1,'A',1000)
insert into TestTable values(3,'C',3000)
select * from TestTable where id=2
Or
select * from TestTable
Index Scan-
If there is any index whether it is clustered or non clustered index if we search like below then its called Index Scan-
Create table TestTable(id int primary key ,Name varchar(100) , Salary int)
insert into TestTable values(2,'B',2000)
insert into TestTable values(1,'A',1000)
insert into TestTable values(3,'C',3000)
select * from TestTable
index seek-
If we search with some condition having index then its called index seek
select * from TestTable where id=2
Greetings! Very useful advice within this post! It's the little changes which will make the biggest changes. Many thanks for sharing!
ReplyDelete