What Is Scan Table/view And Seek Table/view When Its Occurs?

1.	What Is Scan Table/view And Seek Table/view When Its Occurs?
Answer» A Table/view SCAN OCCURS when no USEFUL indexes exist. A TABLE SCAN reads all data, ROW by row, to find the MATCH. A Table/view SCAN occurs when no useful indexes exist. A TABLE SCAN reads all data, row by row, to find the match.

Answer»

A Table/view SCAN OCCURS when no USEFUL indexes exist. A TABLE SCAN reads all data, ROW by row, to find the MATCH.

A Table/view SCAN occurs when no useful indexes exist. A TABLE SCAN reads all data, row by row, to find the match.

Discussion