Articles → SQL SERVER → Index scan and index seek in sql server

Index scan and index seek in sql server




















Software requirement





Technical knowledge















Scan and seek





Click to Enlarge




Click to Enlarge




Types of scan and seek in SQL server













Table Scan







Click to Enlarge



SELECT [PersonId],[PersonName],[Address]  FROM [Test].[dbo].[Person]







Click to Enlarge




Clustered index scan and seek







Click to Enlarge





SELECT [PersonId] ,[PersonName] ,[Address]  FROM [Test].[dbo].[Person] where Personid =1





Click to Enlarge


How isnull functions change the behavior?




select  [Address] from Person where [Address] = 'Address 1'





Click to Enlarge



select  [Address] from Person where Isnull([Address],'') = 'Address 1'





Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, October 01, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250