One-stop resource for everything related to
Oracle Database

fncbased_indx

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…

fncbased_indx

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…

fncbased_indx

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…

fncbased_indx

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…

fncbased_indx

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…

fncbased_indx

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…

fncbased_indx

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…

fncbased_indx

Understanding Oracle SYS_CONTEXT

The SYS_CONTEXT function is used in both SQL & PL/SQL to return information about the Oracle environment that you’re working…

fncbased_indx

Understanding Oracle INSTEAD OF TRIGGER

INSTEAD OF triggers are essentially alternatives to DML triggers. They fire when inserts, updates, and deletes are about to occur;…

fncbased_indx

Understanding Oracle External Tables

External tables are read-only tables that allow Oracle to query data that is stored outside the database in flat files….

fncbased_indx

Understanding ROWID In Oracle Database

Every record has a unique ROWID (pseudocolumn) within a database representing the physical location on disk where the record lives….