Indexes in Oracle :Index Scan Methods :Part 2 

very detailed explanation

I was asked about invisible index today in an interview. I was able to answer it confidently ☺️ Thanks much for making videos in an understandable way👍🙏

Thanks Vivek for sharing the knowledge with us . These videos are awesome . Could you please create videos on the below mentioned topics . . 1. Oracle Wait events - Different types of wait events . 2. OEM -- How to use all the important functions of OEM . 3. AWR report - How to analyse an AWR report . 4. RMAN Backup 5. Explain Plan -- How to analyse an explain plan of a complex query It will be really helpful .. Thanks in advance .

Superb.. explained in a very neat manner.. Thanks for sharing knowledge.

THANKS A LOT, IT WAS SO USEFULL FOR ME😍

awesome.. thanks for sharing

Good explanation... You have a deep knowledge keep it up bro. Thanks

Thanks for providing such a very informative content!!

Very much informative video It tells how deep understanding you are having. Thank you👍

Really nice video,Once Again.Please upload more video related to PerformanceTuning.

Awesome Man!!!! you made learning easy. Please make some real live performance problem videos. till now no one has posted good perf vidoes.

BEST VID ABOUT SCANNING METHODS.. Thanks

Thank you Vivek. Very good explanation. You're the best.

Very informatic session

Thanks a lot for taking time to make such practical videos..

Good explanation bro..your efforts are much appreciated!!

Awesome video!! Waiting for the next tutorial desperately :)

Great Thanks for explaing this in detail

Beautifully explained.

AMAZING EXPLANATION BRO

You are like a google..full of knowledge..

It's really helpful sir

very clear and precise explanation

Thanks Brother

Hi Vivek, really nice explanation...but I have one doubt why in order by 1st column in composite index index full scan and why in order by other column in composite index index fast full scan will be used...I mean what is the exact difference b/w index full scan and index fast full scan . .? Thank u

Thanks a lot for your valuable contents, in the video @2.11 do you mean to create index on foreign key columns? Could you please clarify

Good Explanation Sir.. can you please upload vedio of function based index.

for index fast full scan, you have mentioned that there should not be any order by clause. but if we use any other indexed columns from a composite index except 1stcolumn, it is a fast full index, right? then why it will be a prerequisite of not having order by clause?

I have been studying index from many days but couldn't understand better. Thanks you so much sir for explaining in depth but in simple way. May I know which topics I must go through to better my basics?

Please upload tutorial on Oracle hints and performance tuning plz

Thanks TechCoach for the explanation. I wanted to know how Oracle internally executes the following query : select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal

Thanks Vivek it's really helpful :)

N what is the difference b/w multiblock read and sequential read...I mean in sequential read in index , there is multiblock read as well...please clarify my confusion

I have one question. index range scan does sequential read or multiblock read?

please create one video on B-tree vs bit - map like this one please thanks you :)

in your indexing tutorial 2,u have mentioned that adding a index will eliminate the chance of child table lock in case we delete/update/merge from parent table in a primary key - foreign key relationship... My question is what exactly will happen from index perspective after adding index in child table ...??

IN WHICH CATAGOERY I SHOULD PLACED PRIMARY INDEXING ,SECONDARY INDEXING CLIUSTER INDEXING . ?

does multiblock read in index fast full scan means it will directly read bulk of data from all leaf node

One more doubt, in unique index even if not null constraint is not there , oracle should use unique index scan instead of full table scan since only one null value can exist in the indexed column...I hope u understand what I mean

Do you have any tutorial video for Oracle Hints.If yes Please share Link.

I don't find part-1 of "Indexes in Oracle :Index Scan Methods :Part 1"...Could you please provide the link..

What about clustered and non clustered index could you make a vedio plz

Hello @Tech Coach, The following query gives me an INDEX SKIP SCAN instead of TABLE ACCESS FULL. EXPLAIN PLAN FOR SELECT * FROM INDEX_DEMO WHERE OBJECT_NAME = 'DUAL'; My index looks like this - alter table index_demo add constraint PK_INDEX_DEMO primary key (OWNER, OBJECT_NAME, OBJECT_TYPE, OBJECT_ID); OBJECT_NAME is in the second position but still i get an INDEX SKIP SCAN instead of TABLE ACCESS FULL. Could you kindly explain me why this is happening? Thanks in Advance

I CATAGORIES THE INDEX AS FOLLOW :-  INDEXING IS DEFINED BASED ON ITS INDEXING ATTRIBUTES. INDEXING CAN BE OF THE FOLLOWING TYPES - 1.PRIMARY INDEXING 2.SECONDARY INDEXING. 3.CLUSTER INDEXING.  BASICALLY INDICES ARE OF TWO TYPES 1. ORDERED INDICES. i. DENSE INDEXING ii. SPARSE INDEXING B+TRESS( BALANCED TREE INDEX) BIT MAP 2. HASH INDICES.  INDICES ARE AGAIN DEVIDED ON THE BASICS OF NO. OF ATTRIBUTE 1. SINGLE ATTRIBUTE KEY INDICES I. B+ TREE II. CLUSTER AND NON CLUSTER OR PRIMARY OR SECONDARY INDICES 2. MULTIPLE ATTRIBUTE KEY INDICES. I. BITMAP  INDICES ARE DIVIDED ON THE BASICS OF LEVEL 1. SINGLE LEVEL INDICES 2. MULTI LEVEL INDICES B+ TREE BIT MAP INDEXING.  INDEX ARE CATEGRRIES ON THE BASIS OF STRUCTURE 1. B TRESS INDEX 2. BIT MAP INDEX.

Good one, but I'm still confused about the index fast scan.

Excellent explanation with hands on !! Only suggestion would be speed should be bit low as sometimes getting difficulties to understand.

I M VERY CONFUSED ........😆😆😆😆😆