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

Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One Performance Tuning Bundle. Five courses at a highly discounted price. sqlmaestros.com/all-in-one-bu...
The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.
If you are a fan of live classes, you can explore the SQL Server Performance Tuning Master Class. 40 hours of deep-dive LIVE training. Attend LIVE & get the class recordings for a lifetime. sqlmaestros.com/sql-server-wo...

[@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