SQL Archives - Shoumadip Das

Category: SQL

The “ON PREBUILT TABLE” clause is used when you have already created a replicated table using “CTAS” and now want…

A join view is a view based on a join. Special considerations apply when you issue a DML(INSERT, UPDATE, or…

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

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

A join method is the mechanism for joining two row sources. Depending on the statistics, the optimizer chooses the method…

Clustering is a method of storing tables that are intimately related and often joined together into the same area on…

In earlier Oracle version, QUERY REWRITE feature used to stop working as soon as the materialized view become STALE, unless…

When base tables contain large amount of data, it is expensive and time-consuming to compute the required aggregates or to…