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..
Love to Performance : CONNECT BY PRIOR in Oracle Performance Issue
CONNECT BY PRIOR clause is Oracle provided a great solution for hierarchical queries but connect by prior in Oracle performance issue are headache. It’s because of large dataset misuse of ...
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..
19 New Ways to Create an Index in Oracle
This article explains how to create an index in Oracle and the Types of indexes making considerable performance improvements. Here are 19 ways to create an index and below explain ...
Asiri Gunasena
Read More..
How to Add an Oracle Function Based Index: Unexpected Tips
Oracle function based index enhances the performance with queries that retrieve data using a custom index according to usage. This will improve the performance when consists of function or expression ...
Asiri Gunasena
Read More..
