oracle interview question reverse key index

Подписаться 46 тыс.

Просмотров 44 тыс.

50% 1

Description:
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 indexes?
Click here to subscribe to my youtube channel / @sivaacademy
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...
Oracle PLSQL records and collections at • oracle plsql records a...

Наука

Опубликовано:

2 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 57

@vishalpathak8835 2 года назад

Shiva academy PLSql videos are awesome and simple to understand.. I am trying to switch my company by these videos only..🙏😊

@aniketjagdale7765 4 месяца назад

You are grate sir, I understand every topic you teach

@SivaAcademy 4 месяца назад

My pleasure bro, thank you

@nishanthajay 4 года назад

One of the best videos/material I've ever seen explaining Index contention and reverse key Index. Thank you so much. You deserve a Like and Subscribe :)

@SivaAcademy 4 года назад

It's my pleasure,Thank you so much :-)

@WorldEye88 4 года назад

Very useful and simple way to explain the reverse index pros/cons. Thank you.

@SivaAcademy 4 года назад

Welcome 🙏

@GovindPalanisamy1 3 года назад

Great explanation. Thank you so much.

@SivaAcademy 3 года назад

Welcome bro 💐

@sadashiv975 3 года назад

Super explanation. Every day I am tuning your channel to get some information from your Academy. Thank you so much.

@SivaAcademy 3 года назад

You are most welcome

@sivakrishna5639 2 года назад

One of the best !!!!

@SivaAcademy 2 года назад

Thank you

@lunasworld1110 2 года назад

Hi Siva, thank you very much. I had gone through this video about an year ago ang noted it. But today interviwer asked about index block contention. I was struggled to answer that question. Now again after this video , got refreshed. Thank tou 😀

@SivaAcademy 2 года назад

Great 😊😊👍

@amangoel6971 Год назад

you are a very great person

@SivaAcademy Год назад

My pleasure

@wadigzonDiazwong 2 года назад

excellent, thanks for the explanation!

@SivaAcademy 2 года назад

Welcome

@vijaydubey1734 2 года назад

You are brilliant Siva , such a key points like range scan is not applicable on reverse key index ,rare people will tell these things in any video

@SivaAcademy 2 года назад

My pleasure, thank you bro

@ganeshkamble2737 4 года назад

Excellent

@SivaAcademy 4 года назад

@Ganesh, thanks bro 🙏

@HariHaran-zy6fk 9 месяцев назад

Superb ,,❤❤

@SivaAcademy 4 месяца назад

Thank you

@vedantpawaskar7606 5 лет назад

superbly explain.. Now i understand block contention issue properly and how reverse index works.. how insertion become fast with reverse index ?

@SivaAcademy 5 лет назад

@Vedant, Thanks for your comment. Insertion wont become faster, indexes help to improve query performance., insert will have additional overhead of inserting into index segment as well..

@rpbhagato Год назад

Nice explain. I have one query, if the index key is a varchar column, then how it will reverse it?

@vipul1177 5 лет назад

Hey Siva, its really very well explained a layman can also understand the concept....Have a suggestion, Could you also include a topic, in which scenario/s index could be rebuilt??

@SivaAcademy 5 лет назад

Hi Vipul, Sure, I will add a video on index rebuild scenarios and use cases. Thanks for your comment.

@chalikahani1359 2 года назад

How does Index work with Varchar columns , how is the tree branches and leafs created and how does reverse index work?

@robertcrues 5 лет назад

Hi Siva By default index will have their own impact while insertion. What about reverse key? Can you please explain

@saswatigudli 3 года назад

Is there any explanation for index skip scan ?

@vivekhadoop3359 3 года назад

here question is when reverse key index will be use. can you please tell in which condition this index will be use

@monicabn3067 8 месяцев назад

Hi shiva, Hands down the best explanation. I wanted to understand even though it’s addressing the distribution of data, but what is the point of creating the index if after the select query in the explain plan it’s going for full table search instead of index search? Please kindly help me understand this.

@poonamchauhan5502 2 месяца назад

Reverse indexes are just as efficient as unreversed indexes for finding specific values, although they aren't helpful for range queries. Range queries are uncommon for artificial values such as sequence numbers. When searching the index, the query processor simply reverses the search target before looking it up. I hope this answer helps you to understand the usage of reverse key index.:)

@nishanth3488 3 года назад

How this index works for non numerical values

@pritamswarupajena1194 4 года назад

What is the problem caused by index block contention

@avinashinamdar 4 года назад

To be summarize, Only thing we can use this index when there is lot of index data contention and less use of index rage scan. Correct me if I'm wrong.

@SivaAcademy 4 года назад

Absolutely right

@csekathir1 5 лет назад

Super

@SivaAcademy 5 лет назад

🙏 Thanks bro

@aabha21aug 4 года назад

As usual, very nicely explained Siva! However, I have 2 queries. 1.why would we ever use reverse key index if it does not perform the very function of an index, which is a quick scan using range scan. 2. Also, why would we rebuild such index. Why not simply drop it and create a new index. Thanks!

@SivaAcademy 4 года назад

1. Reverse key index is mainly to avoid index index contention 2. rebuild will not have to recreate the index from scratch

@anandsuman2012 4 года назад

@@SivaAcademy Same Question I am also having, If you say that reverse key solves the index block contention problem , My antenna says how did we get this problem in the first place , because of the index creation , but that normal index would have given some performance also but the reverse key even after solving the index block contention issue does the full table scan.... It better not to have any index at all in such scenario.... please correct me if I am wrong..

@gokulm44 3 года назад

@@anandsuman2012 I have the same question, also the article "docs.oracle.com/cd/A87860_01/doc/paraserv.817/a76970/appanaly.htm#5247" says it maintains the column order but in the video its says it don't.

@sushreeshubha9073 4 года назад

Hi Siva. Could you please explain the global index and clustered and non clustured index

@SivaAcademy 4 года назад

Sure, Please stay tuned.

@pradeepkadam7885 2 года назад

Hi what is clustered index is this part of oracle Or sql server

@c.nbhaskar4718 4 года назад

if full table scan is going on then the performance would be still slow right ?

@SivaAcademy 4 года назад

Yes, but not always. Full table scan would be good in few cases

@hello2439 4 года назад

Where Clustered and non-clustered terminolgy used then sir?

@lekhyadivya2626 3 года назад

Please let us know about partition pruning...

@SivaAcademy 3 года назад

Sure, its already part of my upcoming list, please stay tuned 👍

@jagadishs3931 2 года назад

2:00

@robertcrues 5 лет назад

Hi Siva By default index will have their own impact while insertion. What about reverse key? Can you please explain

@SivaAcademy 5 лет назад

@Robertcrues, Any dml changes to the base table, will impact the underlying index data, hence its applicable for reversekey index as well, good that you raised this point, i will post a video specific on index impact due to DML operations