what is index seek and index scan?
Answers were Sorted based on User's Feedback
Answer / 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 |
which table keeps the locking information? : Sql server administration
How many types of cursors are there in SQL Server?
5 Answers 247Customer, CarrizalSoft Technologies,
Which command executes the contents of a specified file?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What is row_number()?
How do I start sql server agent automatically?
What is the query and subquery?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq
When columns are added to existing tables, what do they initially contain?
What is the advantage of sql server?
How to delete the duplicate rows from a table in SQL Server ??