Indexing in Oracle :B-Tree,Bitmap Indexing

This Video is the 1st tutorial in the video series Indexing in Oracle , The video series explains in detail, What are indexes?It's types, what index should be used in which scenario and other important thing in basic terminology.
Note :You may want to watch the video with a higher playback speed(1.25 if it suits you more)
#OracleIndexing #BTreeIndex #Techcoach

[@harshiniborra4933]

This is the one I found...The most decomplexified explanation of a complex topic..Thanks a million.👏

[@Shashwatoctober]

this information we can not get anywhere else. Such in-depth exlanation. Loved it. Going to binge watch the complete playlist and flaunt my knowledge

[@rohitagrawal2451]

After whole lot of search, One of best tutorial i found on Index .

[@TechCoach]

Thanks a lot Rohit for the kind words.
I need a small help I am working on this new youtube channel and would really appreciate if you watch and subscribe to it.
ua-cam.com/video/HBQHekM1U2c/v-deo.html

[@Crazy4DB]

I suggest put the links of related videos in this series in description box for to be able to find easily

[@PujanShah-o3b]

very nice explanation. It not only clears the concept but also make your optimisation skills more powerful.

[@prasadzagde8210]

Very nicely explained.. Volume and Speed is also very clear and comfortable..Thanks a lot.

[@uzzalbasak2517]

Very Clear concept regarding invisible and unusable Index. :)

[@TechCoach]

Thanks buddy , I am glad I could help:)

[@bhartendukumar5168]

Super se v upar ....,.thanks alot

[@ztech4634]

I agree with Dupati, this is the best video on Index that I have come across! great work.

[@TechCoach]

Thanks a lot for the kind words :)

[@akashkumarmahato-kv1iz]

simply no words. excellent explanation.

[@GauravKumar-ec8vd]

This tutorial is to-the-point. Great job done, sir. Thank you so much.

[@AnIndianAbroadd]

Thanks for the kind words Gaurav.
I have a small request, I am working on this new channel " An Indian Abroad" and will really appreciate if you watch and subscribe to it.
ua-cam.com/video/cvH4oEX3wx8/v-deo.html

[@rohithgorthy971]

It was extremely neat, Very clearly explained in layman terms. Appreciate your efforts. Can you please help us with a use case of B tree index & Bit map index. Thank you.

[@TechCoach]

Hi Rohith, thanks for the kind words.
There are 7 videos in Indexing playlist.
They may answer some of your questions :)
ua-cam.com/play/PLUWdEQb_2yqVXnx-P1881VVtec8moW1sk.html

[@rohitchoubey1809]

Awesome lecture, everything is crystal clear now, thanks again for such an awesome lecture

[@TechCoach]

Thanks Rohit for the kind words,I have a small request
I am working on this new youtube channel, I Would love it if you watch and subscribe to it as well.
Please share with ur friends also.
ua-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

[@therealjordiano]

lovely tutorial bruh thanks

[@anoopakk1562]

Good tutorial

[@TechCoach]

Thanks Buddy :)

[@jawaharthangaraj9185]

Good explanation about indexes with the details of Balanced Search Tree, keep it up.

[@TechCoach]

Thanks Buddy for the kind words.
Please consider subscribing to my other channel as well. It will really help me.
ua-cam.com/video/6G1xGi-D5ow/v-deo.html

[@xxNguyenTungxx]

Thanks for nice shared

[@andrewmarcus5173]

thank you so much. very nice video

[@Eira.2010]

Very nicely explained ..

[@TechCoach]

Thanks Basanti for the kind words.
Please consider subscribing to my other channel as well. It will really help me.
ua-cam.com/video/6G1xGi-D5ow/v-deo.html

[@higurashinilsson1477]

Very good and clear. Thank you!

[@keertisurana8765]

Thanks Vivek. Very nice explanation on Indexing. Very easy to understand. Thanks again.

[@TechCoach]

Thanks a lot for the kind words.
I would really appreciate if you help me in my new Initiative "An Indian Abroad"
by subscribing viewing and sharing.
ua-cam.com/users/AnIndianAbroadd

[@mmanukumar6194]

Hi @Tech coach,
Cab we create B tree indexes in partitioned table?

[@tusharshreshth]

Vivek, Thanks for sharing your knowledge with all of us. If you make an index unusable or invisible then that index will not be used in explain plan. But invisible index will be keep updated by oracle server on applicable statements like INSERT,UPDATE,DELETE. I have one question on this. Can you please explain the same by using trace on select statement?

[@gauravwairagade1490]

Awesome explanation.... Thank you so much Vivek.... Please post some videos for initial data validation in ETL process if possible.

[@TechCoach]

I will be making a video on flat file validation soon, May be that will help. Thanks for the kind words :)

[@TechCoach]

Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
"An Indian Abroad"
ua-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

[@kushagrasrivastava8551]

can you let me know the sql related questions for an experienced professional which are asked in a delloite interview for data analyst

[@dipanjanmukherjee4338]

Superb explanation !!

[@TechCoach]

Glad it was helpful! Dipanjan :)

[@varunagnihotri4812]

Hi, nice explanation. Can you tell me the resources to learn query optimization for a developer or an analyst. I found some books but either they are too complex to understand or too big to digest.
Thanks.

[@dupatisaimanoj5626]

Best video on index still now I haven't seen like this

[@TechCoach]

+dupati sai manoj Thanks for the kind words

[@TechCoach]

Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
"An Indian Abroad"
ua-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

[@kirandalvi3406]

Please make video on Index oraganized table also on performance tunning in explain plan, what is awr report, and processor utilization..please make video on this topic

[@TechCoach]

Sure Kiran I will work on it.

[@pranjalsharma3765]

Thanks a lot ,ur video helped me a lot but where is domain index, descending index and key compression index. These topics are in the content but couldn't find in any of ur index videos.

[@TechCoach]

Hi Pranjal, Thanks for the kind words.
Some videos are pending for Index series I am working on them.
I have a small request I am working on this new channel.
"An Indian Abroad" I will really appreciate if you watch and subscribe to it.
ua-cam.com/video/HBQHekM1U2c/v-deo.html

[@pranjalsharma3765]

Tech Coach Thanks Vivek for ur reply, it's grt to know u r wrking on these topics. I have watched n subscribed ur video 🙂

[@TechCoach]

Thanks a lot buddy, Your help will go a long way with me.

[@hakhandare]

Thanks for sharing valuable knowledge

[@TechCoach]

Thanks Hemant for the kind words :) , I will recommend watching the entire indexing series :)

[@abhijitmane9949]

In Unusable index if actual index is dropped from physical memory then what we are rebuilding? Or it's just index for new data will be dropped?

[@shrutisinghal8556]

Nice video. Thanks Vivek. I am happy that I somehow reached your channel!!

[@TechCoach]

Thanks a lot shruti for the kind words :)

[@_shubhambajaj]

When you rebuilt the index you can actually see the cost was increased by 1. Is it something that usually happens or is it just a session thing, I mean in the next session it will work effectively?? Nice vdo btw

[@TechCoach]

@shubham it should work fine in the next run.
Also thanks for the kind words.
Please consider subscribing to my other channel as well. It will really help me.
ua-cam.com/video/6G1xGi-D5ow/v-deo.html

[@sivaveeramallu3645]

Excellent Explaination

[@TechCoach]

Thanks a lot for the kind words bobby :)

[@tanbhatt3493]

awesome, Thanks for this video

[@TechCoach]

Thanks Tan for the kind words.
I have a small request, I am working on this new youtube channel "An Indian abroad".
It will really help me if you watch and subscribe to it.
ua-cam.com/video/HBQHekM1U2c/v-deo.html

[@amitkumar-ev8im]

Really very nice tutorial.Thanks lot for your help.

[@TechCoach]

Thanks amit for the kind words and my apologies for the delayed reply.

[@HaraprasadSwain]

Pretty crystal. Keep up the good work man.

[@TechCoach]

Thanks HaraPrasad for the kind words :)

[@durgaprasadsriramoji5111]

what do u mean by index clean up? how does drop index differ from making it UNUSED

[@amansinghrajpoot1465]

Setting index unused does not drop the index data but drop index does, you have to use alter table drop unused columns to clean up disk

[@tabithab79]

Great job. Can you make video on performance tuning please?

[@TechCoach]

Thanks a lot, Sure I will try to invest some time for the same

[@TechCoach]

Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
"An Indian Abroad"
ua-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

[@kirannikam4695]

mast yaar... thanks

[@AnIndianAbroadd]

Thanks Kiran.I have a small request, I am working on a new channel " An Indian Abroad" and it will really help me if you watch and subscribe to it.
ua-cam.com/video/QrpPc-WNjoU/v-deo.html

[@dpranow8450]

Great job!!! Tq lot

[@MrRajanSrivastava]

Thanks for making this video, I have a small doubt regarding difference between INDEX UNUSABLE and INDEX DISABLE. as per my understanding DISABLE INDEX can be applied on FUNCTION BASED INDEX, and it can be later REBUILT/ENABLED. Is my understanding correct or is there any other differences?

[@MrRajanSrivastava]

I appreciate your efforts and like your videos very much, and have already subscribed your channel "An Indian Abroad" :)

[@DepMahesh]

Nice explanation, thanks...👍

[@TechCoach]

Thanks a lot Dep Mahesh for the kind words.
I need a small help I am working on this new youtube channel and would really appreciate if you watch and subscribe to it.
ua-cam.com/video/11DK-oyRql0/v-deo.html

[@ankushgondane8642]

This video has great information. Thanks Vivek. Keep it up👍

[@ankushgondane8642]

Vivek please make one video on Explain plan to understand in detail.

[@poojaanand7325]

Thank you for this video. It's really helpful. Could you please provide me with the link for different types of indexes( details like bit map, domain, partitioned etc) since this video doesn't cover that part

[@TechCoach]

Thanks Pooja for the kind words ,
This playlist will help you :)
Indexes in Oracle: ua-cam.com/play/PLUWdEQb_2yqVXnx-P1881VVtec8moW1sk.html

[@bostonarchie6639]

i guess im randomly asking but does someone know a way to get back into an instagram account..?
I was stupid lost the account password. I would love any tips you can give me.

[@titanbarrett6837]

@Boston Archie Instablaster =)

[@bostonarchie6639]

@Titan Barrett thanks so much for your reply. I found the site thru google and I'm waiting for the hacking stuff now.
Seems to take quite some time so I will get back to you later with my results.

[@bostonarchie6639]

@Titan Barrett it worked and I actually got access to my account again. Im so happy!
Thank you so much you saved my account!

[@dhanrajshunkalwar7098]

Very nice explained ... Please explain all the types of indexes

[@TechCoach]

Thanks a lot for the kind words I am in process of completing the indexing series.
I would really appreciate if you help me in my new Initiative "An Indian Abroad"
by subscribing viewing and sharing.
ua-cam.com/users/AnIndianAbroadd

[@ravikhanna29]

good video

[@TechCoach]

Ravinder Khanna Thanks a lot for the kind words, I am working on this new video channel " An Indian abroad" I would really appreciate if you watch and subscribe to it .
ua-cam.com/video/HBQHekM1U2c/v-deo.html

[@hemanthdev8882]

Topic well explained , great going Vivek!!

[@yashwanth990]

Superb explanation sir...

[@AnIndianAbroadd]

Thanks a lot for the kind words, I have a small request I am working on this new youtube channel " An Indian Abroad " and will really appreciate if you watch and subscribe to it.
ua-cam.com/video/11DK-oyRql0/v-deo.html

[@AnIndianAbroadd]

Thanks a lot for the kind words, I have a small request I am working on this new youtube channel " An Indian Abroad " and will really appreciate if you watch and subscribe to it.
ua-cam.com/video/11DK-oyRql0/v-deo.html

[@pavanyadav999]

Thank You for your video.. :)

[@TechCoach]

Thanks for the wonderful comment, I have a small request I am working on this new youtube channel
"An Indian Abroad"
It will really help me if you watch and subscribe to it.
ua-cam.com/video/HBQHekM1U2c/v-deo.html

[@tanvinator]

Vivek, how wonderful. You make it look so simple. ☺️☺️☺️☺️

[@TechCoach]

Thanks Tanvi for the kind words I have a small request
I am working on this new youtube channel, I Would love it if you watch and subscribe to it as well.
ua-cam.com/video/GnVn3mPBRz4/v-deo.html

[@tanvinator]

@@TechCoach done, Sir. ☺️

[@TechCoach]

@@tanvinator thanks a lot :)

[@ztech4634]

What language did you use to create and insert data into the table?

[@TechCoach]

Sql

[@muhammadsaadmansoor7777]

put index of the lecture's topics in description of the video.

[@TechCoach]

Great suggestion, I will do it soon.Thanks Saad Mansoor

[@jeremiahvaliente372]

@@TechCoach will wait for tech coach! Which part of the video exactly is about "Bit Map" indexing? Thanks!

[@PuneetSGoyal]

Hi vivek. Can you add more details on materialised view logs.

[@TechCoach]

Sure Puneet, I will work on it :)

[@PuneetSGoyal]

Tech Coach thanks

[@ur8946]

select * from sales where id =1000; when you run this query as per you comment it need to travel 3 blocks how you are saying 3 block .could you pls clarify my doubt .

[@polishettyanusha]

i have the same doubt, can someone please clarrify

[@divyanamdev886]

Ur voice is nice 👍

[@TechCoach]

Thanks for the kind words.
I have a small request I am working on this new youtube channel "An Indian Abroad" it will really help me if you watch and subscribe to it.
ua-cam.com/video/HBQHekM1U2c/v-deo.html

[@vishalsaxena5081]

please explain non cluster index

[@ayush120793]

Sir you are next TOM( The Oracle Master)...

[@TechCoach]

Hahaha. Thanks Ayush for such kind words :), I am a big fan of ask tom. He has been around for decades. I am no where close to him. But I am trying to keep things simple

[@TechCoach]

Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
"An Indian Abroad"
ua-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

[@syedanoorumar1419]

But the tree ur specifying here is actually a b+ tree because it has all the record pointers in it's leaf nodes.

[@jhaanvi6951]

why are captions disabled....could you please enable captions for all your videos

[@TechCoach]

I am sorry about the captions, Unfortunately youtube is not generating captions for some of my videos. I will try to see if I can find a quick fix

[@MrSaransh]

lets suppose index is invisible and we edit some data in saved data-row. will this edit won't change address of that row? if it changes the address then how can we reuse invisible index as we have older value ? Someone Plz reply

[@TechCoach]

Invisible index is maintained in the background for every single data change, so as soon as we make it visible it will be used in the query plans again( only if it adds value)
I hope it helps, Saransh, please reach out to me if any clarification are required

[@MrSaransh]

@@TechCoach the thing is ... When our databade gets updated then if we make index visible.. will it not cost almost equal to rebuild the index. Because we don't know which reference got changed and we have to verify at all node/key of index .

[@TechCoach]

Nope, when the index is invisible it is maintained and updated like any other index, If you make it unusable then you will have to rebuild the index

[@mohanvilla0789]

Thanks man.. :)

[@TechCoach]

Thanks for the kind words.
I have a small request I am working on this new youtube channel "An Indian Abroad" it will really help me if you watch and subscribe to it.
If you have already subscribed thanks a lot :)
ua-cam.com/video/HBQHekM1U2c/v-deo.html

[@Zovi-kanu]

Sir are you providing live classes of pl plz give your contact details

[@kiran815]

Hi,Please can you share ppt here .

[@starstudio7125]

Create Video On Cluster or non cluster index😅

[@rameshd8436]

This that not visible this that.....

[@TechCoach]

My apologies.

[@mrbushlied7742]

You inserted 100K recorda, not 1M.

[@TechCoach]

My apologies,I will look at it.

[@TheRamesh3342]

insertion was .1 million

[@TechCoach]

Thanks for correcting Ramesh.

[@pasarthivanitha3685]

Screen is not clear

[@TechCoach]

I am sory pasarthi, can you try watching again in HD quality once more please?
I agree some of the content can be difficult to see on mobile

[@starstudio7125]

Create Video On Cluster or non cluster index😅