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

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

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

50% 1

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?
List of all the SQL and PLSQL interview questions @ easy-learning-tech.blogspot.c...

Наука

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

30 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@Variable.Constant. 3 года назад

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.

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

Thanks a lot Kapil, 🙏💐💐

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

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

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

more than expected...keep it up

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

Best Video on Internet related to INDEX.

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

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

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

Welcome bro 🙏💐💙

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

One of the best video on indexes. Thank you!

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

Welcome

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

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

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

Welcome :-), Its my pleasure

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

Really addicted to your vedios.....

@user-dn9fo8xl8o 2 года назад

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

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

My pleasure bro, thank you for your comments 💐💐

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

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.

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

Thank you for your comments, and thanks a lot for sharing with your friends, 💐💐🙏

@aabha21aug 5 лет назад

Too good. Keep up the good work!!

@SivaAcademy 5 лет назад

@aabha, Thanks 🙏 for your comment :-)

@abdulrehman-io7uz 2 года назад

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.

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

Welcome Abdul 💐🙏

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

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

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

Its my pleasure 💐💐

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

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

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

Welcome 💐🙏

@theboharsingh 9 месяцев назад

well structured and organized way to share knowledge.....really good..

@SivaAcademy 9 месяцев назад

Thank you bro

@achyutdeokatepatil897 5 лет назад

What a gerat explaination and knowledge. thanks dada..

@SivaAcademy 5 лет назад

@Achyut, 🙏🙏🙏 for your comments bro

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

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

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

Thank you, sure please stay tuned

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

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?

@vilasgaikwad4141 5 лет назад

Very nice explanations...thanks siva

@SivaAcademy 5 лет назад

@Vilas, Thanks for your comments :-)

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

Your videos are so good n informative that I forgot to like and comment

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

My pleasure, thank you 💐

@16aksi 5 лет назад

Excellent Explanation!!!

@SivaAcademy 5 лет назад

@achyut, Thanks for your comment :-)

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

Very nice more than expected.

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

Welcome 💐🙏💐

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

Thank you so much sir for explaining so nicely....

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

Welcome 🙏

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

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.

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

Great expectation

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

Thank you bro

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

well explained,thank u so much..

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

Welcome bro 💐

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

Very nice Explanation Siva

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

Thank you 🙏

@ManojKumar-il8vt 5 лет назад

Nice explanation sir

@SivaAcademy 5 лет назад

Thanks Manoj

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

Best explanation ever seen😘😍😍 Pls put vedios regards performance tuneing

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

Sure 😊, Thanks for your comments

@ramireddyt1506 5 лет назад

Please post performance tuning videos

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

Superb explanation

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

Thank you 🙂

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

Good explanation I liked it

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

My pleasure

@neerajmishra14 5 лет назад

Amazing, thanks

@SivaAcademy 5 лет назад

@Neeraj, Thanks for your comment :-)

@AliBaba-mx8of 2 года назад

Good explanation sir 👏

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

Thank you

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

This is Gold

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

thanks bro for clear explanations.....

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

Welcome bro 💐

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

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.

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

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

explained perfectly...

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

Thanks bro!! :-)

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

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

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

Like always you nailed it bro🔥

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

thank you bro

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

@@SivaAcademy Would be great if you post video on how to read explain plan.

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

Sure bro

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

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.

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

Fantastic explanation. But i have a doubt. When we create a btree index on ''ename'' column suppose, then how sorting will take place?

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

sorting based on Alpha char, similar to numerical sorting, string sorting will take place

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

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

@1986pramod 4 года назад

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.

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

Can we create a unique index on a non- unique column? If yes, how will indexing work?

@sankarN-wd5nd 3 дня назад

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 ?

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

Hello Sir, what are the privileges we need to have to access v$sql?. Please let me know

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

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

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

Sure, will add to upcoming list of questions, please stay tuned bro

@shiveshpandey1952 5 лет назад

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

@SivaAcademy 5 лет назад

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

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

@@SivaAcademy Can you please share link for performance tuning. i Couldn't find it.

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

Sir, what does "alter table emp modify eno not null" return?

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

Diffrence between selectivity and cardinality?

@palashtarumandal5431 5 лет назад

please create one video on plsql collections (nested table, associative array) in details

@SivaAcademy 5 лет назад

Hi Palash, Thanks for your comment, Here is the video series for collection ru-vid.com/group/PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm more collection Videos will be coming soon in this series, please stay tuned.

@palashtarumandal5431 5 лет назад

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

@SivaAcademy 5 лет назад

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.

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

pls give session Oracle HINTS and which one has to be used based in scenario

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

Sure bro please stay tuned

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

Hi Sir, Plz explain index on null values also

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

Sure, please stay tuned 👍, I will add it to upcoming video list

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

Siva, u forgot to explain the full table scan. Can u pls check it.

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

Will add to upcoming video please stay tuned

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

Please Explain how to take AWR Report

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

Yeah, please stay tuned

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

Yeah we loved it

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

Could you please clarify more IOT

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

Sure, please stay tuned.

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

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 ?