SQL Query Optimization | SQL Query Optimization and performance tuning

[@rasikakurhade1011]

nice way explanation..as I am working on SQL based project, I can relate to all these points

[@muthukumar.m579]

Any vacancy sir

[@rkrrkumar511]

thank you for such excellent content. Hoping for more!

[@coolraviraj24]

completed this whole SQL interview questions as i am also following your ADF series.

[@vishnuraju1901]

Yes please do one video about index Thanks for sharing knowledge

[@learnbydoingit]

Sure

[@seshulatha]

Excellent 🎉

[@arunnkrushna5733]

This is good and simple explanation but please do make it with sql query so that we can see a practical demo

[@TradingwithRam]

Use indexing Replace union with union all Use select instead of select * Minimum use of distinct Don't use ! = or Don't use count, use exist for finding Use like operator wisely Use limit / top to access or check data Avoid multiple joining

[@Prashant-n7s]

Thank you very much sir

[@onlineaccount-wh2yx]

Hi, thank you so much .Can you please make a detailed video on how to optimize query by checking execution plan

[@magdagabrielayanezmarin4449]

This could be very helpful!!

[@shubhamnimbalkar6866]

NICE Explanation but i would be very useful if you have provided examples 😃

[@learnbydoingit]

Will do that

[@ShipraPaliwal]

hi, what is the difference between query optimization and performance tuning with respect to sql query. After checking execution plan what should be next step all mentioned above or do we need to check execution plan later .As we already know the issue how to approach to make sql query run faster.

[@aneelanarayanam]

Using ctes instead of subqueries

[@tedbear1971]

when you say, don't use !=, can you also suggest what method to use otherwise?

[@programershub5494]

How exist and count serve same purpose? And how union and union all serve same purpose?

[@Prashnanth]

DO VIDEO ON THE INDEX WITH TAKING AN EXAMPLE

[@MuruganbiSathya]

Hi bro, . Use EXISTS instead of IN is ok , but how to relate count() and exists

[@chitrarekhatiwari6629]

Thanks

[@learnbydoingit]

👍

[@karthickduraisamy299]

Hi

[@mehmetakifvardar]

Sir I'm sorry but I need to comment this, it was truly a pain listening you. Your mic is understandable you can change that and improve the sound, but the way you talk... Not talking about your accent, you never breathe while you speak. Please pay attention to punctuation. Valuable content though, keep it up.

[@learnbydoingit]

Working on it thanks

[@xainhyder5633]

Not practical way

[@random1-c4y]

This is so funny, you need to fix your Mic

[@learnbydoingit]

Yeah that is the problem please suggest any mic