Author: Shoumadip Das
- Performance Tuning
- October 29, 2024
Understanding REFERENCE PARTITION In Oracle Database.
Reference partitioning is a partitioning method introduced in Oracle 11g. Using reference partitioning, a child table can inherit the partitioning…
- Performance Tuning
- October 29, 2024
Understanding RANGE PARTITION In Oracle Database.
Use RANGE PARTITION when you want to access data on a frequent basis in a large table based on some…
- Performance Tuning
- October 29, 2024
Understanding LIST PARTITION In Oracle Database.
Use list partition when you already have a predefined set of values for which you are expecting the data.You should…
- PL/SQL
- May 26, 2024
Understanding Package Level Caching In Oracle Database.
A package-based cache consists of one or more variables declared at the package level,rather than in any subprogram of the…
- SQL
- May 15, 2024
Understanding Function Based Index In Oracle Database
Traditionally, performing a function on an indexed column in the where clause of a query guaranteed an index would not…
- SQL
- May 15, 2024
Understanding Reverse Key Index In Oracle Database
Reverse B-TREE key indexes reverses the bytes of the key value in the index to reduce Index block contention. Index…
- SQL
- May 4, 2024
Understanding Bitmap Index in Oracle database
BITMAP index are different from B-TREE index in the manner they store data. • B-TREE index stores data in tree…
- 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…
- SQL
- April 14, 2024
Understanding Materialized View ON PREBUILT TABLE
The “ON PREBUILT TABLE” clause is used when you have already created a replicated table using “CTAS” and now want…
- SQL
- April 14, 2024
Understanding DML Statements on a SQL Join View
A join view is a view based on a join. Special considerations apply when you issue a DML(INSERT, UPDATE, or…