What is scan table/view and seek table/view when its occurs? : sql server database administration
- 1 Answers
- 1127 Views
- I also Faced
- E-Mail Answers
Answer Posted / Antul Awashthi
"Scan Table/View": A full scan or table scan is a data retrieval operation in SQL Server where every row of the table or indexed view is read to satisfy a query. It's used when an index isn't available, or the query requires access to unindexed columns.
"Seek Table/View": A seek operation in SQL Server is a data retrieval method that uses an index to find specific rows quickly without reading all the rows of the table or view. The database engine only reads the pages where the matching key values are found."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain “row_number()” in sql server with an example?
Where can you add custom error messages to sql server?
What is normalization and what are the advantages of it?
How to convert numeric expression data types using the cast() function?
What is an indexed view?
Can sql servers link to other servers like oracle?
What are the kinds of subquery?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is a coalesce function?
How to provide default values to function parameters?
What kind of problems occurs if we do not implement proper locking strategy?
How can you append an identity column to a temporary table?
Why we use the openxml clause?
What is a scheduled job or what is a scheduled task?
what is the difference between openrowset and openquery?
