Oracle Interview Question - oracle index related questions - BTREE index in oracle

Oracle Interview Question - oracle index related questions
1. What is Index? How to create index?
2. What are the types of index?
3. How to find the list of indexes for a given table?
4. Explain B-tree index
5. Explain Bitmap index
6. Explain "Function based" index
7. Explain "Reverse Key" index
8. When to choose what type of index?
9. How to know index is being used?
10. How to monitor index usage?
11. What are the advantages/drawbacks of indes?

[poonamchauhan]

Best Video on Internet related to INDEX.

[asifsoft]

One of the best video on indexes. Thanks for the vdo.

[theboharsingh]

well structured and organized way to share good..

[asifsoft]

One of the best video on indexes. Thank you!

[abdulrehman-iouz]

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.

[Variable.Constant.]

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.

[Rizwan]

Excellent explaination, Thanks a lot for making the things simple and easy to understand. 👌

[dhrubaswain]

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

[rajshkr]

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.

[manojjethar]

Hi Siva,
Could you please provide information about Cluster index and non cluster index

[vidyah]

Outstanding explanation sir. Thank you very much for your time and effort.
🙏🙏

[dnfoxlo]

You are making it easy for us!! Fantastic Job Mr. Siva. I would surely recommend your videos to my friends 👌.

[venkkatmerla]

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

[chinmayakumarpadhee]

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?

[sadashiv]

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.

[nandakumar]

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)?

[achyutdeokatepatil]

What a gerat explaination and knowledge. thanks dada..

[sandeepal]

Amazing content and well explained. I learnt alot. Thanks a ton🙏🙏👍👍

[kbalanandam]

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.

[sudarshanraj]

Can you explain about global index vs local index