Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL> select count(*) from t1;
- COUNT(*)
- ----------
- 4023040
- SQL> alter table t1 add primary key (object_id);
- Table altered.
- SQL> select count(*) from t1;
- COUNT(*)
- ----------
- 4023040
- -----------------------------------------------------------------------------------------------
- | Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers |
- -----------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.54 | 8852 |
- | 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.54 | 8852 |
- | 2 | INDEX FAST FULL SCAN| SYS_C004079 | 1 | 3766K| 4023K|00:00:00.35 | 8852 |
- -----------------------------------------------------------------------------------------------
- SQL> select count(distinct(object_id)) from t1;
- COUNT(DISTINCT(OBJECT_ID))
- --------------------------
- 4023040
- --------------------------------------------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | Writes | OMem | 1Mem | Used-Mem | Used-Tmp|
- --------------------------------------------------------------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 1 | | 1 |00:00:05.22 | 8852 | 6944 | 6944 | | | | |
- | 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:05.22 | 8852 | 6944 | 6944 | | | | |
- | 2 | VIEW | VW_DAG_0 | 1 | 3766K| 4023K|00:00:04.96 | 8852 | 6944 | 6944 | | | | |
- | 3 | HASH GROUP BY | | 1 | 3766K| 4023K|00:00:04.47 | 8852 | 6944 | 6944 | 178M| 21M| 32M (1)| 57344 |
- | 4 | INDEX FAST FULL SCAN| SYS_C004079 | 1 | 3766K| 4023K|00:00:00.41 | 8852 | 0 | 0 | | | | |
- --------------------------------------------------------------------------------------------------------------------------------------------------------
Add Comment
Please, Sign In to add comment