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.
@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 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
Very well organized tutorial. Highly appreciated. Thank You.
Thanks Rajat, I am glad I could help :)
Hi Vivek, very well explained.. 👍👍
great contents
I am glad I could help
Thanks for this lucid explanation.
I am glad I could help Saket :)
more power to you vivek....
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.
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
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
Super explanation
Excellent Brother...
I am glad I could help :)
Excellent Explanation 👌👌👌👌👌👌
Thanks Pankaj for the kind words :)
Awesome Explanation.
Thanks a lot buddy :)
Gave me Good understanding... Thank you.
Thanks for the kind words buddy, it means a lot to me
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
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
Well explained. Thanks Vivek
Thanks Hello for the kind words, please forward to someone who may get help from it.
Super
Thanks again buddy :)
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?
awesome
Thanks buddy for the kind words :)
can you ceate a video on what happens if one table has multiple indexes ?
thank you :)
You are welcome :)
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 :)
u r explaining very well in understandable way, but the flow is only slow...
Could you elaborate the key point of logical rowid here please...
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