Category: Performance Tuning
- Performance Tuning
- May 4, 2024
Index Spawning Vs Index Splitting In B-Tree Index
The phenomenon of vertical tree growth or height increase is known as “Index Spawning”. Happens in Auto-incremental scenario. The phenomenon…
- Performance Tuning
- December 5, 2022
Understanding ONLINE Split Partition In Oracle Database 12c.
In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION operations on heap tables can be performed online so they…
- Performance Tuning
- April 25, 2022
Understanding SET TRANSACTION In Oracle 19c
The SET TRANSACTION statement allows you to begin a read-only or read-write session,establish an isolation level,or assign the current transaction…
- Performance Tuning
- May 30, 2021
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…
- 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…