• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Table Scan from Index Scan ?
#1
Hello Dear,

              Please Tell Me Differentiate Table Scan from Index Scan ?
Reply
#2
An index scan or table scan is when SQL Server has to scan the data or index pages to find the appropriate records. A scan is the opposite of a seek, where a seek uses the index to pinpoint the records that are needed to satisfy the query.
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Find The Number Of Rows In A Table Using Mysql ? rajshreedixit01 3 313 09-26-2019, 01:29 AM
Last Post: emmablow
  How many TRIGGERS are allowed in MySql table? gitanistone 0 138 09-25-2019, 01:19 AM
Last Post: gitanistone
  How many columns can be used for creating Index? gitanistone 0 101 09-25-2019, 01:17 AM
Last Post: gitanistone
  How can you see all indexes defined for a table? gitanistone 0 116 09-25-2019, 01:07 AM
Last Post: gitanistone
  What, if a table has one column defined as TIMESTAMP? gitanistone 0 110 09-25-2019, 01:05 AM
Last Post: gitanistone
  How do you control the max size of a HEAP table? gitanistone 0 116 09-25-2019, 01:03 AM
Last Post: gitanistone
  What is the syntax to add a record to a table In Sql ? snehareddy 0 142 09-21-2019, 12:44 AM
Last Post: snehareddy
  select all records from the table In Sql ? snehareddy 0 142 09-21-2019, 12:43 AM
Last Post: snehareddy
  key preserved table ? ranisharma1531 2 223 09-19-2019, 01:04 AM
Last Post: emmablow
  What is a z-index? sulbha 10 1,044 05-13-2019, 01:36 AM
Last Post: lolipop

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


Webmasterbabble.com, © 2012-2020 .