Author: Shoumadip Das

pkg_caching

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…

pkg_caching

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…

pkg_caching

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…

pkg_caching

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…

pkg_caching

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…

pkg_caching

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…

pkg_caching

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…

pkg_caching

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…

pkg_caching

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;…

pkg_caching

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….