Category: Performance Tuning
- Performance Tuning
- April 7, 2021
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…
- Performance Tuning
- March 20, 2021
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…
- Performance Tuning
- November 1, 2020
Understanding INVISIBLE Index
By default an index is VISIBLE.The Oracle optimizer will pick only VISIBLE index. Oracle 11g allows indexes to be marked…
- Performance Tuning
- November 1, 2020
Understanding UNUSABLE Index
By default an index is USABLE.The Oracle optimizer will pick only USABLE index. Oracle indexes can go into a UNUSABLE…