Index in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar

💡 Visit Our Website for Classroom Training:
💡 For Online Training:

#Oracle #Training #CourseVideos

--------------------------

💡 About NareshIT:

"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations

--------------------------

💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.

--------------------------

💡 Please write back to us at

--------------------------

💡 Check The Below Links

[ganeshkashyap]

Not too fast, Not too slow, just at right speed and pace!! Wonderful and correct information.

[manikanta-ydzf]

Sir your tutorials are super, i know u are good trainer .
I am also attended ur regular classes

[ebinvarghese]

its most perfect and simply explained video.

[kiranraghuwanshi]

video is too good, i was not having any idea about indexed, now i am having good idea, thanks you so much sir for this video, its very helpfull

[pavanmadamset]

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

[divyasangeetham]

Your amazing sir, you clarified all doubts of mine regarding index with single video👏👏👏👏👏. Thank you so much☺️

[santoshkori]

I am huge fan of your teaching way.
Thankyou very much 😀

[maheshamara]

It's really awesome. There is no words to say sir. Superb
Both index and materialized views...

[KalyanS]

Nice and good . Naresh tech u r posting useful videos in all technologies. thanks

[nidhikavaidh]

As I have seen a few videoes untill now and liked all videoes.Thanks for such a nice explaination in each videoes.

[kharish]

Its Very Clear Explanation Sir, I Hope You Upload Oracle Architecture 12c :)

[chatrapatia.k]

Hello Sir, I'm your biggest fan...
please share a video regarding Global Temporary Table and what's use of such types of table in real time...

[sravyasreeram]

Very nice explanation Sir....I understood the concept clearly.. Thank you very much

[manish]

This index is on NUMBER datatype column. What if we create a index on VARCHAR2 datatype column? How it will create a B- Tree then? Could you please explain?

[harishbabu]

very nice and clear explanation..good job vijay!

[dhanrajpatel]

Sir, could you please upload the bitmap index video.

[vickypatekar]

Vijay Sir you are the great Thank you So much

[pankajkharade]

my question is how the root node selected by oracle for index creation if root node selection based on the median value then in case of live system data is continuously inserted into the table so each time there will be a change in the median which means a change in root node value.

[ShivShankarPrasadu]

Hello sir,

the b-tree graph that you are using in this tutorial is unbalanced, and b-tree will never be unbalanced.
btree have some property.
Property #1 - All the leaf nodes must be at same level.
Property #2 - All nodes except root must have at least [m/2]-1 keys and maximum of m-1 keys.
Property #3 - All non leaf nodes except root (i.e. all internal nodes) must have at least m/2 children.
Property #4 - If the root node is a non leaf node, then it must have at least 2 children.
Property #5 - A non leaf node with n-1 keys must have n number of children.
E.T.C.

[singamramagangireddy]

Sir, I have been asked by the interviewer many times about Local and Global indexes? What we can say when they have asked about Local and Global indexes. When the indexes become Local and Global.. Please clarify on this?