What is the purpose of gather stats in Oracle

[@winterscent]

This was an awesome video! Thank you so much for the explanation! I was so confused with the dbms_stats.gather_x_stats and was trying to figure out why and how. This cleared out my questions. Really appreciate help.

[@ayanmitra1577]

Starting was bit confusing, but at the end it was explained smoothly. Thanks for the video. Please provide some background before you start a video on any topic. 👍👍👍

[@amitsurjuse7029]

Very good explanation.. got all my doubts clear because of this video.. thank you so much.. Also want to know.. how copy gather stats from one partition to another works

[@MITHLESHKUMAR-vv1cn]

thanks for explaining with example its clear all my doubts

[@parthparth8680]

Good video on ORACLE GATHER STATISTICS, We can use this for Performance Issue on Table

[@mahmudurkhan5754]

Excellent Sir, keep it up :)

[@sreeonfire]

post creating index, expecting execution plan should be index range scan not full scan. but how come it showing alwasy full scan. post stats gather its shows index scan .

[@ShivaKumar-ps1vh]

Best explanation ..👌

[@TechandArt]

Very well keep sharing

[@rakeeshmukkera7593]

Sorry to say this, we are not able to see the commands due to font size.

[@ujjwalsen3231]

Awesome explanation

[@vigneshs1779]

i donot understand he just changed inactive to active by update dml comand , but it didnot change by it self?

[@gotchihaeyo1825]

Thank you🎉

[@prajwalacharya6197]

Well explained

[@abdullahsiddique7787]

Bad idea to create index on low cardinality column

[@atulsrmcem]

very well explained.

[@guptatushar86]

At the beginning, the tutorial starts abruptly and you are totally confused. Viewers please watch first 8 minutes and then it becomes absolutely clear all together, like a magic ! :)

[@SURESHRAJA-c5x]

hi sir, what about index stats ?

[@techforall-tfa5365]

instead of just typing give some introduction and be consistent to the topic.