Description Operation denotes the creation of a table. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi Script SQL> CREATE TABLE old 2 ( 3 id NUMBER 4 ); Table created. SQL> EXPLAIN PLAN FOR CREATE [...]
Archive of posts tagged Oracle
Row Source Operation: SORT CREATE INDEX
Description Sort operation is performed during the creation of an index. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi Script SQL> CREATE TABLE t (n NUMBER, CONSTRAINT t_pk PRIMARY KEY (n)); Table created. SQL> EXPLAIN [...]
Row Source Operation: INDEX BUILD UNIQUE
Description Operation builds an unique index. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi Script SQL> CREATE TABLE t (n NUMBER, CONSTRAINT t_pk PRIMARY KEY (n)); Table created. SQL> EXPLAIN PLAN FOR ALTER INDEX t_pk [...]
Row Source Operation: REMOTE
Description Part of the statement is performed in a REMOTE database. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi Script SQL> CREATE TABLE t (id NUMBER, status VARCHAR2(1)); Table created. SQL> CREATE DATABASE LINK rperumal_dblink [...]
Row Source Operation: MERGE STATEMENT REMOTE
Description UPSERTs row(s) into a table in a remote database. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi Script SQL> CREATE TABLE t (id NUMBER, status VARCHAR2(1)); Table created. SQL> CREATE TABLE q (id NUMBER, [...]
Row Source Operation: SELECT STATEMENT REMOTE
Description SELECTs row(s) from the table on a remote database. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi Script SQL> CREATE DATABASE LINK rperumal_dblink 2 CONNECT TO rperumal IDENTIFIED BY rperumal 3 [...]
Row Source Operation: SELECT STATEMENT
Description SELECTs row(s) from the table. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi Script SQL> CREATE TABLE t 2 ( 3 id NUMBER 4 ); Table created. SQL> EXPLAIN PLAN FOR [...]
Row Source Operation: UNION ALL (RECURSIVE WITH) DEPTH FIRST
Description UNION ALL (RECURSIVE WITH) DEPTH FIRST operation returns the child rows before any siblings rows are returned. This operation was first introduced in Oracle 11g Release 2 (11.2). Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER ————————————————————————— Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – [...]
Row Source Operation: UNION ALL (RECURSIVE WITH) BREADTH FIRST
Description UNION ALL (RECURSIVE WITH) BREADTH FIRST operation returns the sibling rows before any child rows are returned. This operation was first introduced in Oracle 11g Release 2 (11.2). Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER ————————————————————————— Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 [...]
Row Source Operation: PARTITION SYSTEM SINGLE
Description PARTITION SYSTEM SINGLE performs child operations for a single partition in the table. This operation was first introduced in Oracle 11g Release 1. Version This sample script developed and executed on SQL> SELECT banner FROM v$version WHERE rownum = 1; BANNER ——————————————————————————– Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production Script SQL> CREATE TABLE [...]