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 :)
th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

[@rajatkhare6872]

Very well organized tutorial. Highly appreciated. Thank You.

[@TechCoach]

Thanks Rajat, I am glad I could help :)

[@rajeshdas26]

Hi Vivek, very well explained.. 👍👍

[@saidtel1978]

great contents

[@TechCoach]

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....

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

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

[@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 :).
th-cam.com/video/oIkPqhSIctA/w-d-xo.html

[@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.
th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

[@sheelakanagu1036]

Super explanation

[@sameerahmad7592]

Excellent Brother...

[@TechCoach]

I am glad I could help :)

[@pankajkharade6936]

Excellent Explanation 👌👌👌👌👌👌

[@TechCoach]

Thanks Pankaj for the kind words :)

[@vinodkumarmallikarjunaiah44]

Awesome Explanation.

[@TechCoach]

Thanks a lot buddy :)

[@ilangovansubramanian9556]

Gave me Good understanding... Thank you.

[@TechCoach]

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

[@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.
th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

[@devavenueph]

thank you

[@TechCoach]

Thanks buddy , please considee subscribing to my other channel as well
It will really help me
th-cam.com/video/gTg6nCUuYO8/w-d-xo.html

[@dollyphilip20]

Well explained. Thanks Vivek

[@TechCoach]

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

[@Eira.2010]

Super

[@TechCoach]

Thanks again buddy :)

[@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.
th-cam.com/video/DRZChoLPSM8/w-d-xo.html

[@siddhartharao8490]

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

[@dhar8783]

awesome

[@TechCoach]

Thanks buddy for the kind words :)

[@Shashwatoctober]

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

[@shubhendrasingh8486]

thank you :)

[@TechCoach]

You are welcome :)

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

[@palanivelu.a]

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

[@vasanthayamala8423]

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

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