Answer Posted / sumit
Index Scan is nothing but scanning on the data pages from
the first page to the last page. If there is an index on a
table, and if the query is touching a larger amount of
data, which means the query is retrieving more than 50
percent or 90 percent of the data, and then optimizer would
just scan all the data pages to retrieve the data rows. If
there is no index, then you might see a Table Scan (Index
Scan) in the execution plan.
Index seeks are generally preferred for the highly
selective queries. What that means is that the query is
just requesting a fewer number of rows or just retrieving
the other 10 (some documents says 15 percent) of the rows
of the table.
In Index Scan the cost is proportional to the total number
of rows in the table. Thus, a scan is an efficient strategy
if the table is small or if most of the rows qualify for
the predicate.
In Index Seek the cost is proportional to the number of
qualifying rows and pages rather than to the total number
of rows in the table.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Can select statements be used on views in ms sql server?
How do I setup a local sql server database?
What is difference in performance between insert top (n) into table and using top with insert?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is table valued function and scalar valued functions?
Can we update data in a view?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Explain few examples of RDBMS?
What have included columns when we talk about sql server indexing?
What is meant by referential integrity?
What are the advantages of using cte?
How do I view a stored procedure in sql server query?
What are different types of collation sensitivity?
What is clr ddl trigger?
Explain security with sql azure?
