Dears
I am just curious to know what this operation (INDEX MAINTENANCE) that I have never seen before stand for?
SQL Plan Monitoring Details (Plan Hash Value=1129128534)
=========================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs |
| | | | (Estim) | | Active(s) | Active | |
=========================================================================================================================
| 0 | MERGE STATEMENT | | | | | | 17 |
| 1 | PX COORDINATOR | | | | | | 17 |
| 2 | PX SEND QC (RANDOM) | :TQ10006 | 1G | 4M | | | |
| 3 | INDEX MAINTENANCE | THIS_IS_A_HEAP_TABLE | | | | | |
Is it simply saying that is it filling up the THIS_IS_A_HEAP_TABLE table indexes (only one index which is the PK index)?
Thanks
Mohamed Houri