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 filed under the Oracle category.
Row Source Operation: INDEX BUILD NON UNIQUE
Description Operation builds a non-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 (id NUMBER); Table created. SQL> EXPLAIN PLAN FOR CREATE INDEX t_id ON t(id); Explained. Execution Plan [...]
Row Source Operation: CREATE INDEX STATEMENT
Description Operation denotes the execution of create index statement. 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); Table created. SQL> EXPLAIN PLAN FOR CREATE INDEX t_id ON t(id); [...]
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: MERGE STATEMENT
Description UPSERTs row(s) into 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 (id NUMBER, status VARCHAR2(1)); Table created. SQL> CREATE TABLE q (id NUMBER, status VARCHAR2(1)); Table created. [...]
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 [...]