What is Full Table Scan in Oracle | Quick Guide
What is Full Table Scan in Oracle? Simply it reads all the rows in the table. If you have a Where condition, then filter records according to that. Normally oracle ...
Asiri Gunasena
Read More..
2 Reasons to Why Oracle Index Full Scan
An Oracle index full scan is Oracle start read block from ROOT and then navigating to the down branch until find the leaf block on the left side. Move to ...
Asiri Gunasena
Read More..
How to Understand Oracle Index Unique Scan
If the table has primary keys then you can scan through the unique index. oracle index unique scan stops the scanning process once the first record is found. A unique ...
Asiri Gunasena
Read More..
Oracle Bitmap Index Unleashed: Optimization Made Easy
Oracle provides this nice data retrieving mechanism for low occurrence of DML operation tables. oracle bitmap index is proposed for low cardinality columns. Those kinds of columns in a query ...
Asiri Gunasena
Read More..
