Hi Mohamad, That statement was for an access path 'Index Full Scan' where you do not read only the required entries from the Index, but scans the entire Index and its tree like structure from top to bottom. This is almost same like doing a full scan on a table (with slight improvements only), and thats how the Index Scan and Table scans becomes almost same in case kf a INDEX FULL SCAN. Hope I am able to clarify! Have a great day Prashant 'The FatDBA'
Hi Prashant, Videos are very informative. Could you please upload remaining part of videos?
Hi Prashant, eagerly waiting for next two videos on this topic.
Hi prashant, at 22:33 while explaining Index full scan you said Index is exact replica of the table. Can you pls explain what exactly it means.
Hi Mohamad,
That statement was for an access path 'Index Full Scan' where you do not read only the required entries from the Index, but scans the entire Index and its tree like structure from top to bottom. This is almost same like doing a full scan on a table (with slight improvements only), and thats how the Index Scan and Table scans becomes almost same in case kf a INDEX FULL SCAN.
Hope I am able to clarify!
Have a great day
Prashant 'The FatDBA'
@@thefatdba Thanks for explaining and giving time.