1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | explain plan for create index orders_ix01 on orders (customer_id, order_mode) ; select * from table (dbms_xplan.display) ; Plan hash value: 4214405511 ------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------ | 0 | CREATE INDEX STATEMENT | | 4654K| 53M| 9085 (1)| 00:02:48 | | | | 1 | INDEX BUILD NON UNIQUE | ORDERS_IX01 | | | | | | | | 2 | SORT CREATE INDEX | | 4654K| 53M| | | | | | 3 | PARTITION HASH ALL | | 4654K| 53M| 6746 (1)| 00:02:05 | 1 | 64 | | 4 | TABLE ACCESS FULL | ORDERS | 4654K| 53M| 6746 (1)| 00:02:05 | 1 | 64 | ------------------------------------------------------------------------------------------------------ |