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

[@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.
ruclips.net/video/HBQHekM1U2c/видео.html

[@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

[@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:)

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

[@bhartendukumar5168]

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

[@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.
ruclips.net/video/6G1xGi-D5ow/видео.html

[@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.
ruclips.net/video/cvH4oEX3wx8/видео.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.
ruclips.net/channel/UCoLdaMxhfDgdgIAcRGlUvkg

[@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.
ruclips.net/video/6G1xGi-D5ow/видео.html

[@anoopakk1562]

Good tutorial

[@TechCoach]

Thanks Buddy :)

[@xxNguyenTungxx]

Thanks for nice shared

[@therealjordiano]

lovely tutorial bruh thanks

[@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.
ruclips.net/user/AnIndianAbroadd

[@hakhandare]

Thanks for sharing valuable knowledge

[@TechCoach]

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

[@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 :)
ruclips.net/p/PLUWdEQb_2yqVXnx-P1881VVtec8moW1sk

[@andrewmarcus5173]

thank you so much. very nice video

[@dipanjanmukherjee4338]

Superb explanation !!

[@TechCoach]

Glad it was helpful! Dipanjan :)

[@higurashinilsson1477]

Very good and clear. Thank you!

[@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"
ruclips.net/channel/UCoLdaMxhfDgdgIAcRGlUvkg

[@sivaveeramallu3645]

Excellent Explaination

[@TechCoach]

Thanks a lot for the kind words bobby :)

[@mmanukumar6194]

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

[@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.
ruclips.net/user/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 .
ruclips.net/video/HBQHekM1U2c/видео.html

[@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 :)

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

[@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.
ruclips.net/video/11DK-oyRql0/видео.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.
ruclips.net/video/11DK-oyRql0/видео.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.

[@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"
ruclips.net/channel/UCoLdaMxhfDgdgIAcRGlUvkg

[@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.
ruclips.net/video/HBQHekM1U2c/видео.html

[@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.
ruclips.net/video/11DK-oyRql0/видео.html

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

[@HaraprasadSwain]

Pretty crystal. Keep up the good work man.

[@TechCoach]

Thanks HaraPrasad for the kind words :)

[@kushagrasrivastava8551]

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

[@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?

[@ankushgondane8642]

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

[@ankushgondane8642]

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

[@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.
ruclips.net/video/HBQHekM1U2c/видео.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.

[@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.
ruclips.net/video/GnVn3mPBRz4/видео.html

[@tanvinator]

@@TechCoach done, Sir. ☺️

[@TechCoach]

@@tanvinator thanks a lot :)

[@_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.
ruclips.net/video/6G1xGi-D5ow/видео.html

[@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

[@hemanthdev8882]

Topic well explained , great going Vivek!!

[@dpranow8450]

Great job!!! Tq lot

[@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.
ruclips.net/video/HBQHekM1U2c/видео.html

[@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" :)

[@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"
ruclips.net/channel/UCoLdaMxhfDgdgIAcRGlUvkg

[@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: ruclips.net/p/PLUWdEQb_2yqVXnx-P1881VVtec8moW1sk

[@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!

[@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.
ruclips.net/video/HBQHekM1U2c/видео.html

[@ztech4634]

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

[@TechCoach]

Sql

[@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.
ruclips.net/video/QrpPc-WNjoU/видео.html

[@PuneetSGoyal]

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

[@TechCoach]

Sure Puneet, I will work on it :)

[@PuneetSGoyal]

Tech Coach thanks

[@syedanoorumar1419]

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

[@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

[@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"
ruclips.net/channel/UCoLdaMxhfDgdgIAcRGlUvkg

[@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

[@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!

[@vishalsaxena5081]

please explain non cluster index

[@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

[@kiran815]

Hi,Please can you share ppt here .

[@Zovi-kanu]

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

[@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 :)
ruclips.net/video/HBQHekM1U2c/видео.html

[@rameshd8436]

This that not visible this that.....

[@TechCoach]

My apologies.

[@starstudio7125]

Create Video On Cluster or non cluster index😅

[@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😅