Pages

Wednesday, August 21, 2013

SQL SERVER – Index Seek Vs. Index Scan (Table Scan) | Journey to SQL Authority with Pinal Dave

Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. Index Scan: Since a scan touches every row in the table whether or not it qualifies, the cost is proportional to the total number of rows in the table. Thus, a scan is an efficient strategy if the… Continue Reading...

Source: SQL SERVER – Index Seek Vs. Index Scan (Table Scan) | Journey to SQL Authority with Pinal Dave