Author: Shoumadip Das
- SQL
- July 4, 2021
Understanding Materialized View Query Rewrite
When base tables contain large amount of data, it is expensive and time-consuming to compute the required aggregates or to…
- Performance Tuning
- May 30, 2021
Understanding Oracle Index Scan Methods
INDEX SCAN define how the Optimizer will traverse the index block to get the result. It is a access path…
- Performance Tuning
- April 7, 2021
Behavior Of DETERMINISTIC & RESULT_CACHE Function In Oracle 19c
Oracle Database Cache improves the scalability and performance of applications that access Oracle databases by caching frequently used data on…
- Performance Tuning
- March 20, 2021
Index Organized Tables In Oracle
Index Organized Tables ( IOT ) have their primary key data and non-key column data stored within the same B*Tree…
- PL/SQL
- February 21, 2021
Collection As Table Column Datatype
In PL/SQL,we can use both VARRAY & NESTED TABLE collection type as table column datatype. The difference between these implementation…
- Architecture
- January 14, 2021
Understanding LOCKING In Database
CONCURRENT access is accessing same data by multiple users at the same time. • SHARED lock is acquired when user…
- Architecture
- December 13, 2020
Understanding TRANSACTIONS In Database
What Is A Transaction ? Transaction is logically joining multiple SQL statements (unit of work) which we can either commit/rollback.In…
- PL/SQL
- November 23, 2020
PL/SQL Collection Methods
WHAT IS COLLECTION ? A collection is a data structure that acts like a list or a single-dimensional array of…
- Architecture
- November 8, 2020
Understanding FLASHBACK Technology
In Oracle database,under SGA there is an optional memory component known as – Flashback buffer.When Flashback Database is enabled, the…
- Performance Tuning
- November 1, 2020
Understanding INVISIBLE Index
By default an index is VISIBLE.The Oracle optimizer will pick only VISIBLE index. Oracle 11g allows indexes to be marked…