What is difference between index seek vs. Index scan?
- 1 Answers
- 1235 Views
- I also Faced
- E-Mail Answers
Answer Posted / Chandrakant Giri
{"index_seek_vs_scan": "Index seek is a fast method of retrieving rows from an index when the query uses an SEEK operation and specifies an exact value or range for the key column(s). In contrast, index scan reads all the pages of the index sequentially to fetch the required data. Scans are slower than seeks but may be necessary for queries that don't have a specific key value or seek criteria."}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How do I create a trace in sql server?
What are different types of constraints?
What are the different subsets of sql?
List the ways in which dynamic sql can be executed?
What is clustered index
What is acid mean in sql server?
How to provide default values to function parameters?
What are the source of constraints?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How raid can influence database performance?
What is the primary use of the model database?
Can we shrink data file in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
