tag:blogger.com,1999:blog-830335965541290967.post8446829363407117447..comments2024-03-28T19:23:33.737+05:30Comments on Knowledge Sharing: Difference Between Index Seek vs Index ScanSaurabh Sinhahttp://www.blogger.com/profile/11120038651556545818noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-830335965541290967.post-83433329121580184022016-05-16T09:27:34.988+05:302016-05-16T09:27:34.988+05:30SQL - Index Scan Vs Table Scan
In absence of the i...SQL - Index Scan Vs Table Scan<br />In absence of the indexes, A table scan will work on the data pages and this scanning starts from the first page to the last page for the data and in this way, scanned table stands on a heap and these data rows have their own pages. In the table scan, every row of data goes into the data scanning. If we have the huge data in the table and no index is not there then the query execution cost will increase due to high volume table scan.<br /><a href="http://www.sql-datatools.com/2016/05/sql-index-scan-vs-table-scan.html" rel="nofollow">SQL - Index Scan Vs Table Scan</a>Mukesh Singhhttps://www.blogger.com/profile/10793266909993773163noreply@blogger.comtag:blogger.com,1999:blog-830335965541290967.post-33138895406074501232016-04-19T10:49:27.572+05:302016-04-19T10:49:27.572+05:30Nice Article !
Really this will help to people of...Nice Article !<br /><br />Really this will help to people of Database Community. <br />I have also prepared small note on this, What is difference between Table Scan, Index Scan and Index Seek?.<br /><br />http://www.dbrnd.com/2016/04/database-theory-table-scan-vs-index-scan-vs-index-seek/Anonymoushttps://www.blogger.com/profile/01365030762397385247noreply@blogger.comtag:blogger.com,1999:blog-830335965541290967.post-8035763452324529742015-01-14T21:30:22.470+05:302015-01-14T21:30:22.470+05:30Welcome !!Welcome !!Saurabh Sinhahttps://www.blogger.com/profile/11120038651556545818noreply@blogger.comtag:blogger.com,1999:blog-830335965541290967.post-75670196720252951372015-01-14T12:15:56.683+05:302015-01-14T12:15:56.683+05:30Thank you sir :)Thank you sir :)gannghttps://www.blogger.com/profile/04095624198492456431noreply@blogger.com