Author: Shoumadip Das

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

- SQL
- April 3, 2024
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…

- PL/SQL
- April 3, 2024
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;…

- SQL
- February 23, 2024
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….

- Architecture
- December 18, 2023
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….

- PL/SQL
- July 17, 2023
Log Sub-Program Parameter Values Using LOG4PL/SQL Framework In Oracle Database 19c
LOG4PLSQL is an open source tool that uses PL/SQL framework to log into PL/SQL code package,function,web application,procedure, trigger and various…

- Architecture
- January 22, 2023
Understanding Index Compression In Oracle Database 19c
From Oracle 9i onward both non-unique and unique indexes can be compressed to save disk space. The COMPRESS [N] clause…