Category: Performance Tuning

oracle_index_scan

Understanding Oracle Index Scan Methods

INDEX SCAN define how the Optimizer will traverse the index block to get the result. It is a access path…

deterministic_result_cache

Behavior Of DETERMINISTIC & RESULT_CACHE Function In Oracle 19c

Oracle Database Cache improves the scalability and performance of applications that access Oracle databases by caching frequently used data on…

iot

Index Organized Tables In Oracle

Index Organized Tables ( IOT ) have their primary key data and non-key column data stored within the same B*Tree…

Understanding-Invisible-Index

Understanding INVISIBLE Index

By default an index is VISIBLE.The Oracle optimizer will pick only VISIBLE index. Oracle 11g allows indexes to be marked…

Understanding UNUSABLE Index

By default an index is USABLE.The Oracle optimizer will pick only USABLE index. Oracle indexes can go into a UNUSABLE…