@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
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.
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 :)
Maza Aagya explanation dekh k.
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
great contents
I am glad I could help
Very well organized tutorial. Highly appreciated. Thank You.
Thanks Rajat, I am glad I could help :)
more power to you vivek....
Hi Vivek, very well explained.. 👍👍
Thanks for this lucid explanation.
I am glad I could help Saket :)
Excellent Brother...
I am glad I could help :)
Super explanation
Excellent Explanation 👌👌👌👌👌👌
Thanks Pankaj for the kind words :)
Nice , very helpful
And explain better
@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
Awesome Explanation.
Thanks a lot buddy :)
Thank u for the precious info shared through this video. Keep doing great 👏
@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
very nice explanation sir
Thanks a lot for the kind words Shubhendra, Keep watching for new videos :). Happy learning:)
@Shubhendra, This Video on functional indexing may Interest you as well :).
th-cam.com/video/oIkPqhSIctA/w-d-xo.html
Superb explanation. I was struggling to understand IOT and this video cleared all my doubts. Thank u so much🤩 please keep making more videos
Thanks a lot for the kind words buddy :)
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.
Gave me Good understanding... Thank you.
Thanks for the kind words buddy, it means a lot to me
Well explained. Thanks Vivek
Thanks Hello for the kind words, please forward to someone who may get help from it.
thank you
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
Super
Thanks again buddy :)
awesome
Thanks buddy for the kind words :)
thank you :)
You are welcome :)
thanks a lot Vivek!!
Do you have videos on Hints and table/index cluster?
Not Yet hemant, I will make some videos on hint soon :)
Hi Hemant, Check out this video.
It may interest you.
th-cam.com/video/DRZChoLPSM8/w-d-xo.html
Good explanation, Sir. But Sir, What is the point of using Primary key in IOT?
If the relation table index segments rearrange themself on insertion then why we rebuild index after huge DMLs?
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 :)
can you ceate a video on what happens if one table has multiple indexes ?
Could you elaborate the key point of logical rowid here please...
u r explaining very well in understandable way, but the flow is only slow...
You said IOT and regular table have Id as primary key. How oracle which know which is IOT and regular?
The syntax for the two is different, you have to use keyword organization index for IOT