CREATE TABLE t1000
AS
SELECT rownum AS num
FROM all_objects
WHERE rownum <= 1000Table created.
SELECT table_name, num_rows, blocks
FROM tabs
WHERE table_name = 'T1000'| TABLE_NAME | NUM_ROWS | BLOCKS | T1000 | 1000 | 5 |
|---|
CREATE TABLE t2 (
num NUMBER
)Table created.
SELECT table_name, num_rows, blocks
FROM tabs
WHERE table_name = 'T2'| TABLE_NAME | NUM_ROWS | BLOCKS | T2 | - | - |
|---|
INSERT
INTO t2
SELECT rownum AS num
FROM all_objects33735 row(s) inserted.
COMMITStatement processed.
SELECT table_name, num_rows, blocks
FROM tabs
WHERE table_name = 'T2'| TABLE_NAME | NUM_ROWS | BLOCKS | T2 | - | - |
|---|
TRUNCATE TABLE t2Table truncated.
INSERT /*+ APPEND */
INTO t2
SELECT rownum AS num
FROM all_objects33735 row(s) inserted.
COMMITStatement processed.
SELECT table_name, num_rows, blocks
FROM tabs
WHERE table_name = 'T2'| TABLE_NAME | NUM_ROWS | BLOCKS | T2 | 33735 | 58 |
|---|
EXPLAIN PLAN
FOR
CREATE TABLE brand_new_table
AS
SELECT *
FROM t1000Table created.
SELECT * FROM table(DBMS_XPLAN.display)| PLAN_TABLE_OUTPUT | Plan hash value: 1310973320 | ---------------------------------------------------------------------------------------------------- | | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | | ---------------------------------------------------------------------------------------------------- | | 0 | CREATE TABLE STATEMENT | | 1000 | 4000 | 4 (0)| 00:00:01 | | | 1 | LOAD AS SELECT | BRAND_NEW_TABLE | | | | | | | 2 | OPTIMIZER STATISTICS GATHERING | | 1000 | 4000 | 3 (0)| 00:00:01 | | | 3 | TABLE ACCESS FULL | T1000 | 1000 | 4000 | 3 (0)| 00:00:01 | | ---------------------------------------------------------------------------------------------------- |
|---|