Oracle数据库：全局索引的ONLINE重建要注意影响(二)

- cpu costing is off (consider enabling it)
　　15 rows selected.
　　SQL> EXPLAIN PLAN FOR ALTER INDEX T_ID_IDX REBUILD PARTITION SYS_P226 ONLINE;
　　Explained.
　　SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
　　PLAN_TABLE_OUTPUT
　　----------------------------------------------------------------------------------------------------
　　Plan hash value: 78911014
　　-----------------------------------------------------------------------------------
　　| Id | Operation | Name | Rows | Bytes | Cost | Pstart| Pstop |
　　-----------------------------------------------------------------------------------
　　| 0 | ALTER INDEX STATEMENT | | 50617 | 247K| 56 | | |
　　| 1 | INDEX BUILD NON UNIQUE| T_ID_IDX | | | | | |
　　| 2 | SORT CREATE INDEX | | 50617 | 247K| | | |
　　| 3 | PARTITION RANGE ALL | | 50617 | 247K| 56 | 1 | 6 |
　　|* 4 | TABLE ACCESS FULL | T | 50617 | 247K| 56 | 1 | 6 |
　　-----------------------------------------------------------------------------------
　　Predicate Information (identified by operation id):
　　---------------------------------------------------
　　4 - filter(TBL$OR$IDX$PART$NUM("TEST"."T",58596,0,1048576,"I