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

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@dumpling6440]

What happens if we keep more than 1 or 2 col in index and only one condition in where clause. How will it work???

[@techtrends.programming]

Index in SQL Explained in precise and to the point, kzbin.info/www/bejne/j6LdcpKbYtNgqrM

[@ganeshkashyap8573]

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

[@manikanta-yd7zf]

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

[@kiranraghuwanshi1012]

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

[@ebinvarghese4239]

its most perfect and simply explained video.

[@pavanmadamset]

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

[@AugustineWamala-f2r]

thank you Sir, love from Senegal Dakar. West Africa.

[@santoshkori8992]

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

[@maheshamara7612]

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

[@divyasangeetham4385]

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

[@kuldipmahale9762]

Excellent Explanation Sir !!!

[@sravyasreeram8816]

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

[@nidhikavaidh6468]

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

[@harishbabu6450]

very nice and clear explanation..good job vijay!

[@KalyanS]

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

[@kharish525]

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

[@keshavgupta633]

Best video to learn indexing in sql

[@kishorpatil37]

thanks sir...very good explanation

[@jinalvipani6075]

Nicely explained with example !!!!

[@lalchandnagargoje9708]

Good

[@vickypatekar9532]

Vijay Sir you are the great Thank you So much

[@manish8067]

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?

[@jitendraverma3783]

Thankyou so much Very well explained

[@HariHaran-zy6fk]

Well mannered explanation

[@divyavani1213]

very good explanation sir

[@chatrapatia.k1885]

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

[@Dhiepiga]

Global temporary table is a temporary table once if the action is done it will automatically get closed best example is ticket booking in app (if the end user books the ticket in app that session is blocked once the transaction has done and that particular seat will not shows to other user Evan if the transaction is not completed after that end user left the app then that session will get closed its called global temporary table)

[@dhanrajpatel8746]

Sir, could you please upload the bitmap index video.

[@crazyvedika145]

Very well explained..

[@mathaiissac1587]

Thank you, helps a lot!

[@rjraob]

Excellent explanation.

[@pankajkharade6936]

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.

[@90medha]

Very nice explanation 👍

[@sivaram8726]

Thank You. Mr.Vijay..!!

[@ShivShankarPrasad4u]

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.

[@giridharkumar4067]

Nicely explained

[@singamramagangireddy721]

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?

[@sindhuc7359]

Best teacher

[@ramgoomohan9301]

Thanks u r uploaded video.

[@sarsatheeshreddy3341]

super sir pls upload few more videos

[@aiswarya3461]

Thank you Sir !

[@RUGVEDGAMING99]

Please upload video on bit map and function base index also

[@sunilraj5454]

AUTOTRACE IN NOT WORKING IN MYSQL..SUGGEST THE QUERY FOR MYSQL

[@amitsinha3082]

Thanks !

[@manivannanv3806]

excellent

[@shwetashelar965]

very usefull

[@ajinkyamore3288]

Can you please add Oracle videos of Murali sir also....

[@mithundwivedi8146]

Hello Naresh, Could you please load the query performance vedio.

[@ishikakokane6606]

Can any one explain me how that btree is formed I didn't get that

[@shumailasami2277]

What are cluster index and non cluster index

[@nishakicooking1236]

Sir ... you have to explain with example why are Wasting our time in faltu tree explain

[@bayyadwaraka9412]

obsoletely A1 teaching

[@mohitshinde000]

between 8:00 to 8:30 time kehna kya chahte hoo🤣🤣🤣🤣🤣

[@sss_1507]

sir,which software we have to install to execute this programmes

[@mallikmalyala2976]

GO TOHOW TO INSTALL ORACLE BY MANISH SHARMA,I FOUNF IT VERY EASY

[@vamsireddy5051]

SQL developer or SQL plus softwares

[@rohitpandey9986]

Hello Sir, Nice explanation. I have some doubts: 1. How that main index root node is decided to be 3000? 2. Does Btree indexing sorts the column values at the time of index creation within itself because salary column is majorly non-sorted column and Btree seems applicable on sorted records only? Please clarify. Thanks!

[@surendrakappa1383]

1. At first he writes one query in that query sal=3000, based on searched value btree structure created...

[@abhilashjajula7775]

Please send sql syllabus

[@nehadubey7192]

Bitmap???

[@sarsatheeshreddy3341]

oracle videos upload pls

[@Pankaj-je1qx]

Why are you repeating same line..??

[@janardhanreddyboyalla2941]

Sir you nalied it

[@nareshe9906]

what about the other index type how it works..?

[@ramblermayur6431]

Very nice explained 🙂

[@ramgoomohan9301]

Thanks u r uploaded video.

[@dqplys]

Thank you sir