Dear Siva, There is a lot of content on the internet but this one is surely a masterpiece. Also, you have put so much effort in editing the videos so that the explanation is creating an impact. Kudos!! Would love to see more videos on performance tuning. Subscribed and going to share your channel in my network.
@SivaAcademy4 жыл бұрын
Thanks a lot Kapil, 🙏💐💐
@asifsoft78615 жыл бұрын
One of the best video on indexes. Thank you!
@SivaAcademy4 жыл бұрын
Welcome
@Rizwan0794 жыл бұрын
Excellent explaination, Thanks a lot for making the things simple and easy to understand. 👌
@SivaAcademy4 жыл бұрын
Welcome bro 🙏💐💙
@asifsoft78615 жыл бұрын
One of the best video on indexes. Thanks for the vdo.
@theboharsingh Жыл бұрын
well structured and organized way to share knowledge.....really good..
@SivaAcademy Жыл бұрын
Thank you bro
@poonamchauhan55028 ай бұрын
Best Video on Internet related to INDEX.
@abdulrehman-io7uz2 жыл бұрын
Dear Siva, your way of explaining is quite fascinating. You are literally making PLSQL very easy to understand for naive people like me. Thanks, Dear.
@SivaAcademy2 жыл бұрын
Welcome Abdul 💐🙏
@ramireddyt15065 жыл бұрын
Please post performance tuning videos
@dhrubaswain15783 жыл бұрын
The explanation is at its best. Ready to spent time and learn from here instead of browsing here and there. Please continue the basic and simplicity of the concepts
@SivaAcademy3 жыл бұрын
Welcome :-), Its my pleasure
@rajshkr7864 жыл бұрын
As mentioned you have created an index and queried in the condition using those indexed columns with min and max functions, so instead of having full index(min/max) being used in the access path, isn't that a feasible way to create a function-based index using min and max functions on those columns.
@satya87634 жыл бұрын
more than expected...keep it up
@sadashiv9753 жыл бұрын
Hi Shiv, Amazing knowledge transfer is happening from your "Shiv Academy". I am gaining knowledge from your end. I have searched a lot to learn PLSQL here and there but finally got the right path. I have already shared your channel in my groups. I just loved it. Thank you so much.
@SivaAcademy3 жыл бұрын
Thank you for your comments, and thanks a lot for sharing with your friends, 💐💐🙏
@user-dn9fo8xl8o3 жыл бұрын
You are making it easy for us!! Fantastic Job Mr. Siva. I would surely recommend your videos to my friends 👌.
@SivaAcademy3 жыл бұрын
My pleasure bro, thank you for your comments 💐💐
@rampradeepkalivarapu37223 жыл бұрын
Really addicted to your vedios.....
@manojjethar2202Ай бұрын
Hi Siva, Could you please provide information about Cluster index and non cluster index
@vidyah87873 жыл бұрын
Outstanding explanation sir. Thank you very much for your time and effort. 🙏🙏
@SivaAcademy3 жыл бұрын
Welcome 💐🙏
@nandakumar47762 жыл бұрын
How the B-Tree index will work on transactional table? Where huge volume of data is getting inserted everyday. Will it re-generate / refresh the B-Tree every time when the table in updated(for each transaction)?
@aabha21aug5 жыл бұрын
Too good. Keep up the good work!!
@SivaAcademy5 жыл бұрын
@aabha, Thanks 🙏 for your comment :-)
@bhojrajsingh8737 Жыл бұрын
Hi Shiva, In Index fast full scan you have created index on emo no and sal column but you have not used any one of the column in where condition. Will index hit in this scenerio??
@suryatanyarout35513 жыл бұрын
Your videos are so good n informative that I forgot to like and comment
@SivaAcademy3 жыл бұрын
My pleasure, thank you 💐
@sankarN-wd5nd5 ай бұрын
If we created composite index on three columns and we are we using in where clause only two columns or one column from that index. Will it still do the index scan ?
@venkkatmerla43894 ай бұрын
Hi Siva, Thank you for the vedio your explanation is super good, I don’t know how I missed your vedios from last 5 years , very informative content. If there some possibility try to do some tunning vedios in depth
@SivaAcademy4 ай бұрын
Welcome bro, sure please stay tuned, will cover in upcoming videos
@venkkatmerla43894 ай бұрын
Hi Siva, I am watching your vedios from a couple of weeks ago, I just want to know about the domain index purpose and it is usage , when I am creating a domain index it is taking lot of time , I have gone through some blogs but I did not get the clear , can you please help on this domain index . Thanks
@sandeepal13 жыл бұрын
Amazing content and well explained. I learnt alot. Thanks a ton🙏🙏👍👍
@SivaAcademy3 жыл бұрын
Its my pleasure 💐💐
@arunrocketz4 жыл бұрын
Great explanation and i just got immersed in ur video and with ur knowledge..Learning a lot by watching ur videos daily..one request sir can you please upload the day to day activities of a sql/plsql developer ..
@SivaAcademy4 жыл бұрын
Thank you, sure please stay tuned
@1986pramod4 жыл бұрын
Can there be multiple indexes created with same name. If not, then, is there a oracle that oracle would show composite index as Normal. I can see 2 columns in USER_IND_COLUMNS. But, USER_INDEXES > Index Type is Normal. Can you provide some guidance on such scenario.
@shitaljadhav52943 жыл бұрын
Very nice more than expected.
@SivaAcademy3 жыл бұрын
Welcome 💐🙏💐
@siddhartharao84904 жыл бұрын
Sir, what does "alter table emp modify eno not null" return?
@kbalanandam4 жыл бұрын
Can you share video on Hash, Nested Loop and Sort Merge join along with in depth of knowledge in terms of the way they works ? Thank you.
@AliBaba-mx8of2 жыл бұрын
Good explanation sir 👏
@SivaAcademy2 жыл бұрын
Thank you
@chinmayakumarpadhee92352 жыл бұрын
Hi Siva. Loved your explanation. One doubt what is the best practice to create index ? Before insertion of data or after insertion of data in the table?
@achyutdeokatepatil8975 жыл бұрын
What a gerat explaination and knowledge. thanks dada..
@SivaAcademy5 жыл бұрын
@Achyut, 🙏🙏🙏 for your comments bro
@garigasravyasree16312 жыл бұрын
Sir.I have seen that we have 2 types of index like clustered and non clustered. But here there are other index types. Can you tell what exactly need to answer for types of indexes.
@vilasmuley95905 жыл бұрын
Fantastic explanation. But i have a doubt. When we create a btree index on ''ename'' column suppose, then how sorting will take place?
@SivaAcademy4 жыл бұрын
sorting based on Alpha char, similar to numerical sorting, string sorting will take place
@abhinav121rocks4 жыл бұрын
Sir... If function based index is used bcz otherwise we cant use functions in an SQL statement and yet have the index get used... Then howcome we were able to use sum and max functions on a non function based index....
@akshayphadnis4 жыл бұрын
Can we create a unique index on a non- unique column? If yes, how will indexing work?
@sudarshanraj37835 ай бұрын
Can you explain about global index vs local index
@vivektarab162 ай бұрын
00:56 - Start with B - Tree 02:34 - What is a B - Tree Index 07:13 - Where to Find Metadata Information 9:09 - How to find Whether the Index is used by the Query 11:52 - When to Create B Tree Index 13:40 - Range Scan 15:14 - Unique Scan 19:52 - Index Fast Full Scan 22:04 - Advantages and Disadvantages of B - Tree Index
@kamaleshr64194 жыл бұрын
Hello Sir, what are the privileges we need to have to access v$sql?. Please let me know
@vilasgaikwad41416 жыл бұрын
Very nice explanations...thanks siva
@SivaAcademy6 жыл бұрын
@Vilas, Thanks for your comments :-)
@champakalibhattacharjee96793 жыл бұрын
Siva please teach us to debug a very big query that are mainly found in real life examples..300 lines or 3000 lines code...procedure function etc...
@SivaAcademy3 жыл бұрын
Sure, will add to upcoming list of questions, please stay tuned bro
@anthamsuprithareddy19973 жыл бұрын
Good explanation I liked it
@SivaAcademy3 жыл бұрын
My pleasure
@FactsHeaven3 жыл бұрын
Great expectation
@SivaAcademy3 жыл бұрын
Thank you bro
@firebird90954 жыл бұрын
Diffrence between selectivity and cardinality?
@16aksi5 жыл бұрын
Excellent Explanation!!!
@SivaAcademy5 жыл бұрын
@achyut, Thanks for your comment :-)
@RamGuptaoracle5 жыл бұрын
Very nice Explanation Siva
@SivaAcademy5 жыл бұрын
Thank you 🙏
@deepti73973 жыл бұрын
Superb explanation
@SivaAcademy3 жыл бұрын
Thank you 🙂
@rajabaskar11054 жыл бұрын
Best explanation ever seen😘😍😍 Pls put vedios regards performance tuneing
@SivaAcademy4 жыл бұрын
Sure 😊, Thanks for your comments
@vedashwi3 жыл бұрын
well explained,thank u so much..
@SivaAcademy3 жыл бұрын
Welcome bro 💐
@veggourmet14674 жыл бұрын
thanks bro for clear explanations.....
@SivaAcademy4 жыл бұрын
Welcome bro 💐
@elenabit10954 жыл бұрын
Thank you so much sir for explaining so nicely....
@SivaAcademy4 жыл бұрын
Welcome 🙏
@knowledgebox96912 жыл бұрын
Like always you nailed it bro🔥
@SivaAcademy2 жыл бұрын
thank you bro
@knowledgebox96912 жыл бұрын
@@SivaAcademy Would be great if you post video on how to read explain plan.
@SivaAcademy2 жыл бұрын
Sure bro
@muralik4794 жыл бұрын
pls give session Oracle HINTS and which one has to be used based in scenario
@SivaAcademy4 жыл бұрын
Sure bro please stay tuned
@raghuveerlakkampelli95913 жыл бұрын
Please Explain how to take AWR Report
@SivaAcademy3 жыл бұрын
Yeah, please stay tuned
@raghuveerlakkampelli95913 жыл бұрын
Yeah we loved it
@palashtarumandal54316 жыл бұрын
please create one video on plsql collections (nested table, associative array) in details
@SivaAcademy6 жыл бұрын
Hi Palash, Thanks for your comment, Here is the video series for collection kzbin.info/aero/PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm more collection Videos will be coming soon in this series, please stay tuned.
@palashtarumandal54316 жыл бұрын
@@SivaAcademy Hi Siva thanks for your reply. Your vedios are really good. I saw ur collection vedios ,they are at basic level.could you please carate one vedio with when to use varry ,when to use nested table and frequently asked questions in interview.it will be very helpful.
@SivaAcademy6 жыл бұрын
Hi Palash, Sure I will create one video covering the difference and when to use what time of collection. Once the basic set of collection videos are uploaded, i will upload the differences and interview questions specific to collection, so its easy for every one to follow. However, i will try to cover the most important collection related interview questions as soon as possible. Thanks for your comments, Stay tuned for more videos.
@dasubabuch15964 жыл бұрын
Siva, u forgot to explain the full table scan. Can u pls check it.
@SivaAcademy4 жыл бұрын
Will add to upcoming video please stay tuned
@ManojKumar-il8vt6 жыл бұрын
Nice explanation sir
@SivaAcademy6 жыл бұрын
Thanks Manoj
@akashsoni64195 жыл бұрын
Could you please clarify more IOT
@SivaAcademy5 жыл бұрын
Sure, please stay tuned.
@TysonGill3 жыл бұрын
This is Gold
@dhavalpandya41624 жыл бұрын
Hi Sir, Plz explain index on null values also
@SivaAcademy4 жыл бұрын
Sure, please stay tuned 👍, I will add it to upcoming video list
@jay.shah965 жыл бұрын
So primary key index is a b-tree type index?
@SivaAcademy4 жыл бұрын
Yes
@brizesalvator80864 жыл бұрын
explained perfectly...
@SivaAcademy4 жыл бұрын
Thanks bro!! :-)
@neerajmishra145 жыл бұрын
Amazing, thanks
@SivaAcademy5 жыл бұрын
@Neeraj, Thanks for your comment :-)
@shiveshpandey19525 жыл бұрын
Hi sir this the most important video for the interview whether the fresher or experience guy .Sir if you have separate video for the performance tuning please share. Thanks Sir..
@SivaAcademy5 жыл бұрын
@Shivesh, I just started performance tuning video series...will be posting all the performance tuning videos in that series, please stay tuned for more videos.
@Dineshk04164 жыл бұрын
@@SivaAcademy Can you please share link for performance tuning. i Couldn't find it.
@jiyelaljaiswal74584 жыл бұрын
explanation Plan show index when I execute : select count(*) from table_name where ? explanation Plan DOES NOT show index when I execute : select * from table_name where ?