Author: Shoumadip Das

for_update

Understanding SELECT FOR UPDATE In Oracle Database

The SELECT FOR UPDATE statement is a special variation of the normal SELECT statement, which proactively issues row locks on…

for_update

Understanding COMPOSITE/SUB PARTITION In Oracle Database.

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

for_update

Understanding HASH PARTITION In Oracle Database.

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

for_update

Understanding INTERVAL PARTITION In Oracle Database.

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

for_update

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…

for_update

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…

for_update

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…

for_update

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…

for_update

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…

for_update

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…