Shoumadip Das - Page 3 of 7 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

Bind Variable Peeking Introduced in 9i,in bind variable peeking (also known as bind peeking), the optimizer looks at the value…

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…

A package-based cache consists of one or more variables declared at the package level,rather than in any subprogram of the…

Traditionally, performing a function on an indexed column in the where clause of a query guaranteed an index would not…

Reverse B-TREE key indexes reverses the bytes of the key value in the index to reduce Index block contention. Index…

BITMAP index are different from B-TREE index in the manner they store data. • B-TREE index stores data in tree…

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

The “ON PREBUILT TABLE” clause is used when you have already created a replicated table using “CTAS” and now want…