Oracle || Indexes Part-1 by dinesh 

Thank you sir,i don't have much money to join the courses in Hyderabad so i am using to watch these videos,heart full thanks to dinesh sir and durga soft

This video is both incredibly well explained and hilarious. Dinesh explains things in a speed and way so that even I can understand them. He repeats them multiple times and explains in numerous different ways which is really good. On the other hand, his English very funny. It's generally very well understandable, but at times you just burst out laughing. All in all this video get's 5 of 5 stars, it's very informative and just as funny. Thank you Dinesh!

You are so amazing.... You taught all things in details an in easy way.. You are same like IIT professors

Thanks a lot sir, very informative video. These types of teachers are asset of the world.

Excellent Explanation Sir! Thank You Very Much, Dinesh Sir!!! I am learning because of You Sir!!!

Great content! No doubt he has a sound knowledge of database. Thank you very much for the video :-)

very nice and clear the concepts of indexes..thanks a lot to dinesh sir

Thanks for share this kind of videos. Learn a lot from it.

Very detailed real time explanation. Thanku sir.

thank you so much sir for explaining so briefly and nicely. It makes us so easy to understand.

nice explanation. Learned a new concept today - 'Egg Nest'. very hepful

thanks a lot sir for uploading remaining videos

Thanks a bunch! I was able to understand your explaination. You know what you are talking about. This helps me a lot with my daily work :D

Awesome crystal clear explanation sir. Hats Off

Simple and clear. Thanks alot sir

very good class, thank you! Greetings from Brazil.

Thank you so much sir.. hope you keep it up..

not from india and this video helped me

Thanks Dinesh it is very well explained.

Thank you Sir. Nicely explained.

Great Explanation . I really like it. But you create your column with unique constraint then its already consider as unique index like primary key. Oracle 12cR2

Very good explained !

thanks sir for special guidance

Thanks for sharing knowledge

what a nice explanation sir thanks

Thank you Sir ..

Ecellent Sir.......Awesome

great sir thanks

hats off to you sir

bahut achha

excellent explanation

thank you sir very helpful

Nice

Thanks!

DEAR SIR. Do you have any video about deferring constraints ..

More knowledgeable person

Thx

"Suppose all males are mapped to 0 and all females to 1...." why ??? because women are always right !!!! >D >D >D

very nice explanation sir ,May I know what is Tree walking in oracle?

Hi Dinesh, isn't there any video from your side on Cluster. If it's there then kindly help me & provide the link for the Video related to Cluster....... Thanks Sameer Ahmad

explanation is good... thank u sir

amazingly helpful .

Hi Sir, If need to create index in where clause how can we create it.?

Sir please explain force and mview by dinesh sir

It's very nice but the bit map index internal mechanism how it works not clear in the video. If it z possible please share another video.

Could you link the next part in the description?

sir i think u should get treatment of your coughing issue or is it your style!!!....>>>>>>

sir missing some portion after 16:40min , please check and update

Example required for index on varchar column

16:39 why the cut? that was something which is not explained in other videos.

Please provide tuning concepts

There are no. of videos which are turned private do something for that?

ple the upload the force,metirilized views

Hey, I have a doubt. At 8:20, for finding the first value that fails the constraint *salary < 7000* , we are scanning one by one from top till we make the 4th comparison that fails. Now imagine, the constraint is *salary < 15000*. In this case, according to the said approach, we would still be traversing sequentially until we reach the last element which is still *O(N)* destroying the very purpose of using an index. Shouldn't the condition make use of *Upper bound* function that runs in *logarithmic O(log(n)* time. It would translate as follows: sal < 7000 : upper_bound(idx_sal, 7000 - 1) : index :3 sal < 15000: upper_bound(idx_sal, 15000 -1 ): index 13 -> All rows Let me know what you guys think.

nice explanation. but how do I identify missing indexes?

Part 2 ?

agnest??

Thanks 🙏