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
@dumpling64403 жыл бұрын
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.programming2 жыл бұрын
Index in SQL Explained in precise and to the point, kzbin.info/www/bejne/j6LdcpKbYtNgqrM
@ganeshkashyap85737 жыл бұрын
Not too fast, Not too slow, just at right speed and pace!! Wonderful and correct information.
@manikanta-yd7zf6 жыл бұрын
Sir your tutorials are super, i know u are good trainer . I am also attended ur regular classes
@ebinvarghese4239 Жыл бұрын
its most perfect and simply explained video.
@kiranraghuwanshi10123 жыл бұрын
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
@divyasangeetham43854 жыл бұрын
Your amazing sir, you clarified all doubts of mine regarding index with single video👏👏👏👏👏. Thank you so much☺️
@pavanmadamset7 жыл бұрын
Excellent Explanation Sir! Thank You Very Much, Vijay Kumar Sir!!! I am learning because of You Sir!!!
@kuldipmahale9762Ай бұрын
Excellent Explanation Sir !!!
@santoshkori89926 жыл бұрын
I am huge fan of your teaching way. Thankyou very much 😀
@maheshamara76122 жыл бұрын
It's really awesome. There is no words to say sir. Superb Sir..... Both index and materialized views...
@KalyanS4 жыл бұрын
Nice and good . Naresh tech u r posting useful videos in all technologies. thanks
@nidhikavaidh64686 жыл бұрын
As I have seen a few videoes untill now and liked all videoes.Thanks for such a nice explaination in each videoes.
@keshavgupta6332 жыл бұрын
Best video to learn indexing in sql
@kharish5257 жыл бұрын
Its Very Clear Explanation Sir, I Hope You Upload Oracle Architecture 12c also...... :)
@chatrapatia.k18857 жыл бұрын
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...
@Dhiepiga5 жыл бұрын
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)
@manish80676 жыл бұрын
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?
@sravyasreeram88163 жыл бұрын
Very nice explanation Sir....I understood the concept clearly.. Thank you very much
@divyavani1213 Жыл бұрын
very good explanation sir
@harishbabu64507 жыл бұрын
very nice and clear explanation..good job vijay!
@dhanrajpatel87466 жыл бұрын
Sir, could you please upload the bitmap index video.
@kishorpatil376 жыл бұрын
thanks sir...very good explanation
@HariHaran-zy6fk2 жыл бұрын
Well mannered explanation
@vickypatekar95325 жыл бұрын
Vijay Sir you are the great Thank you So much
@jitendraverma37833 жыл бұрын
Thankyou so much Very well explained
@jinalvipani60757 жыл бұрын
Nicely explained with example !!!!
@lalchandnagargoje97086 жыл бұрын
Good
@pankajkharade69364 жыл бұрын
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.
@crazyvedika1453 жыл бұрын
Very well explained..
@mathaiissac15873 жыл бұрын
Thank you, helps a lot!
@ramblermayur64313 жыл бұрын
Very nice explained 🙂
@ShivShankarPrasad4u6 жыл бұрын
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.
@rjraob5 жыл бұрын
Excellent explanation.
@giridharkumar40673 жыл бұрын
Nicely explained
@dqplys Жыл бұрын
Thank you sir
@singamramagangireddy7217 жыл бұрын
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?
@aiswarya34613 жыл бұрын
Thank you Sir !
@sindhuc73593 жыл бұрын
Best teacher
@sivaram87267 жыл бұрын
Thank You. Mr.Vijay..!!
@RUGVEDGAMING995 жыл бұрын
Please upload video on bit map and function base index also
@ramgoomohan93015 жыл бұрын
Thanks u r uploaded video.
@manivannanv38064 жыл бұрын
excellent
@sarsatheeshreddy33417 жыл бұрын
super sir pls upload few more videos
@rohitpandey99866 жыл бұрын
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!
@surendrakappa13836 жыл бұрын
1. At first he writes one query in that query sal=3000, based on searched value btree structure created...
@mithundwivedi81467 жыл бұрын
Hello Naresh, Could you please load the query performance vedio.
@ajinkyamore32887 жыл бұрын
Can you please add Oracle videos of Murali sir also....
@shwetashelar9656 жыл бұрын
very usefull
@sss_15077 жыл бұрын
sir,which software we have to install to execute this programmes
@mallikmalyala29766 жыл бұрын
GO TOHOW TO INSTALL ORACLE BY MANISH SHARMA,I FOUNF IT VERY EASY
@vamsireddy50515 жыл бұрын
SQL developer or SQL plus softwares
@nishakicooking12365 жыл бұрын
Sir ... you have to explain with example why are Wasting our time in faltu tree explain
@sunilraj54547 жыл бұрын
AUTOTRACE IN NOT WORKING IN MYSQL..SUGGEST THE QUERY FOR MYSQL
@shumailasami22775 жыл бұрын
What are cluster index and non cluster index
@abhilashjajula77754 жыл бұрын
Please send sql syllabus
@nehadubey71922 жыл бұрын
Bitmap???
@bayyadwaraka9412 Жыл бұрын
obsoletely A1 teaching
@sarsatheeshreddy33417 жыл бұрын
oracle videos upload pls
@Pankaj-je1qx4 жыл бұрын
Why are you repeating same line..??
@janardhanreddyboyalla29413 жыл бұрын
Sir you nalied it
@mohitshinde0008 ай бұрын
between 8:00 to 8:30 time kehna kya chahte hoo🤣🤣🤣🤣🤣