Performance Tuning Archives

Category: Performance Tuning

Composite partitioning OR sub partitioning is a partitioning technique in which the table is initially partitioned by the first data…

Hash partitioning is a partitioning technique where a hash key generated through a hashing algorithm is used to distribute rows…

Interval partitioning method is introduced in Oracle 11g. This is an extension to range partitioning where Oracle automatically creates a…

Reference partitioning is a partitioning method introduced in Oracle 11g. Using reference partitioning, a child table can inherit the partitioning…

Use RANGE PARTITION when you want to access data on a frequent basis in a large table based on some…

Use list partition when you already have a predefined set of values for which you are expecting the data.You should…

The phenomenon of vertical tree growth or height increase is known as “Index Spawning”. Happens in Auto-incremental scenario. The phenomenon…

In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION operations on heap tables can be performed online so they…

The SET TRANSACTION statement allows you to begin a read-only or read-write session,establish an isolation level,or assign the current transaction…

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