SCAN vs SEEK Performance - What to look for? (SQL Server Query Tuning) (by Amit Bansal)

[@ravulakishan5998]

ur way of explanation is awsome sir

[@pramodmaurya6610]

Thanks for your efforts and knowledge sharing.. 👍👍

[@RajneeshDabral]

thanks

[@saranreddy3011]

Got to learn something new

[@atulborale2706]

I am going through the issue, where my table is having about 84 million records and we are reading the whole lot table in sp without any where clause, is there any way I can improve the performance for this table. TIA

[@RajneeshDabral]

are you reading the complete data of the table?

[@atulborale2706]

@@RajneeshDabral Yes, it's an old code where it is simply joining on primary key and no where clause. Simply select all data from that table and then further add few more tables in joining that's it