tag:blogger.com,1999:blog-694855878384792308.post2330317909571398431..comments2024-03-21T06:26:49.387-07:00Comments on Java67: Difference between table scan, index scan, and index seek in SQL Server Database? Examplejavin paulhttp://www.blogger.com/profile/15028902221295732276noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-694855878384792308.post-83752711306980136712021-04-26T11:37:50.431-07:002021-04-26T11:37:50.431-07:00Awesome Thank You Sir.Awesome Thank You Sir.Anonymoushttps://www.blogger.com/profile/09659793054148500865noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-24458797688373022192020-04-09T23:07:59.036-07:002020-04-09T23:07:59.036-07:00Thanks Boris, yes, you are right but topic is real...Thanks Boris, yes, you are right but topic is really important in this age of data and performance. javin paulhttps://www.blogger.com/profile/15028902221295732276noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-79309595623032964502020-04-09T23:07:30.604-07:002020-04-09T23:07:30.604-07:00Thank you Rohit, glad you find it usefulThank you Rohit, glad you find it usefuljavin paulhttps://www.blogger.com/profile/15028902221295732276noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-19436548026457789062020-04-09T23:07:11.370-07:002020-04-09T23:07:11.370-07:00Some times a bad query plan is cached, did you try...Some times a bad query plan is cached, did you try with upating stats? what does the query plan looks like and what query you are running?javin paulhttps://www.blogger.com/profile/15028902221295732276noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-7411581037219826562020-04-05T19:34:13.231-07:002020-04-05T19:34:13.231-07:00Hi,
Great article but I think I have an exception...Hi, <br />Great article but I think I have an exception for your guidelines, let's go there. I have a table with almost two billion of rows and a Index Seek is far away slower than table scan, the first takes 1 hour and the second takes 20 seconds. Some information about this table: partitioned, one non clustered index, tree physical files for whole table, querying all columns (40+).<br /><br />Any explanations for this behaviour?<br /><br />Thanks in advance.Anonymoushttps://www.blogger.com/profile/10220729625988003679noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-8790573769232934362020-01-15T03:37:13.918-08:002020-01-15T03:37:13.918-08:00Awesome Explanation Sir, this article helps to und...Awesome Explanation Sir, this article helps to understand the index scan, seek n detail.rohit guptahttps://www.blogger.com/profile/07499052841976875587noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-46191687985117265332019-02-04T08:37:30.471-08:002019-02-04T08:37:30.471-08:00Great explanation to a topic that is always neglec...Great explanation to a topic that is always neglected by many SQL developers and even some DBAs Boris Iriartehttps://www.blogger.com/profile/13140213880198193972noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-54182011965346501632018-08-08T06:35:03.572-07:002018-08-08T06:35:03.572-07:00Thanks Manas, glad this article help you. Thanks Manas, glad this article help you. javin paulhttps://www.blogger.com/profile/15028902221295732276noreply@blogger.comtag:blogger.com,1999:blog-694855878384792308.post-86532074929711509472018-08-08T03:10:57.831-07:002018-08-08T03:10:57.831-07:00Nice Article , My doubts got cleared about the dif...Nice Article , My doubts got cleared about the difference between index scan and index seek .Anonymoushttps://www.blogger.com/profile/10870340037258290297noreply@blogger.com