Index Organized Table in Oracle|IOT Oracle|Tech Coach

[@akashkumar2938]

Maza Aagya explanation dekh k.

[@TechCoach]

Thanks Akash, please consider subscribing to my other channel as well it will really help me :) kzbin.info/www/bejne/bHiUqXqfYqlopdk

[@rajeshdas26]

Hi Vivek, very well explained.. 👍👍

[@rajatkhare6872]

Very well organized tutorial. Highly appreciated. Thank You.

[@TechCoach]

Thanks Rajat, I am glad I could help :)

[@MrSakssssss]

Thanks for this lucid explanation.

[@TechCoach]

I am glad I could help Saket :)

[@vedashwi]

more power to you vivek....

[@saidtel1978]

great contents

[@TechCoach]

I am glad I could help

[@vasanthayamala8423]

Thank u for the precious info shared through this video. Keep doing great 👏

[@TechCoach]

@Vasantha thanks for the kind words. Please consider subscribing to my other channel as well. It will really help me. kzbin.info/www/bejne/bHiUqXqfYqlopdk

[@gauravsujay9391]

Hi Vivek big fan for you. you help us to clear lots of doubt in oracle.thanks a lots of sharing your knowledge in such a easy way. if you have time, do explain architecture of oracle also. keep sharing your knowledge.

[@anitha6661]

Superb explanation. I was struggling to understand IOT and this video cleared all my doubts. Thank u so much🤩 please keep making more videos

[@TechCoach]

Thanks a lot for the kind words buddy :)

[@sameerahmad7592]

Excellent Brother...

[@TechCoach]

I am glad I could help :)

[@ilangovansubramanian9556]

Gave me Good understanding... Thank you.

[@TechCoach]

Thanks for the kind words buddy, it means a lot to me

[@pankajkharade6936]

Excellent Explanation 👌👌👌👌👌👌

[@TechCoach]

Thanks Pankaj for the kind words :)

[@sheelakanagu1036]

Super explanation

[@shubhendrasingh8486]

very nice explanation sir

[@TechCoach]

Thanks a lot for the kind words Shubhendra, Keep watching for new videos :). Happy learning:)

[@TechCoach]

@Shubhendra, This Video on functional indexing may Interest you as well :). kzbin.info/www/bejne/pXrOgaSeiK6WqqM

[@vinodkumarmallikarjunaiah44]

Awesome Explanation.

[@TechCoach]

Thanks a lot buddy :)

[@satishsharma-yh4hy]

Nice , very helpful

[@satishsharma-yh4hy]

And explain better

[@TechCoach]

@satish sharma Please consider subscribing to my other channel as well. It will really help me. kzbin.info/www/bejne/bHiUqXqfYqlopdk

[@dollyphilip20]

Well explained. Thanks Vivek

[@TechCoach]

Thanks Hello for the kind words, please forward to someone who may get help from it.

[@siddhartharao8490]

Good explanation, Sir. But Sir, What is the point of using Primary key in IOT?

[@bhaskarsharma3338]

If the relation table index segments rearrange themself on insertion then why we rebuild index after huge DMLs?

[@TechCoach]

Hi bhaskar, sometimes its more cost effective to build the entire index again instead of the rearrangement. Which is why in lot of cases you will see that the team will 1st drop the index perform the data load and then recreate it. I hope this helps :)

[@devavenueph]

thank you

[@TechCoach]

Thanks buddy , please considee subscribing to my other channel as well It will really help me kzbin.info/www/bejne/nYXKZ6F5itqMhZo

[@Shashwatoctober]

can you ceate a video on what happens if one table has multiple indexes ?

[@hakhandare]

thanks a lot Vivek!! Do you have videos on Hints and table/index cluster?

[@TechCoach]

Not Yet hemant, I will make some videos on hint soon :)

[@TechCoach]

Hi Hemant, Check out this video. It may interest you. kzbin.info/www/bejne/eoO9dJulgbWGg5o

[@vasanthayamala8423]

Could you elaborate the key point of logical rowid here please...

[@palanivelu.a]

u r explaining very well in understandable way, but the flow is only slow...

[@shubhendrasingh8486]

thank you :)

[@TechCoach]

You are welcome :)

[@dhar8783]

awesome

[@TechCoach]

Thanks buddy for the kind words :)

[@Eira.2010]

Super

[@TechCoach]

Thanks again buddy :)

[@dineshkalva3884]

You said IOT and regular table have Id as primary key. How oracle which know which is IOT and regular?

[@TechCoach]

The syntax for the two is different, you have to use keyword organization index for IOT