SQL Performance
I am little bit confused as I see 2392555633 would be the best PHV to create a sql baseline or sqlprofile but when I see explain plan 2392555633 seems very bad PHV for baseline creation and 3456048781 looks good one.
PLAN_HASH_VALUE AVG_ET_SECS
--------------- -----------
2392555633 2.396-------Here it sems good PHV for baseline
2317165185 8.255
3776114006 38.08
895145127 106.062
1822069265 108.826
305450620 410.778
3456048781 498.286
2792127502 650.387---Here it seems bad PHV for base line
Please find plan for both PHV and suggest why it is so?
3456048781:--Shows best plan
Plan hash value: 3456048781
-----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | | | 1 (100)| |
| 1 | LOAD TABLE CONVENTIONAL | | | | | |
| 2 | NESTED LOOPS ANTI | | 1 | 244 | 1 (0)| 00:00:01 |
| 3 | NESTED LOOPS ANTI | | 1 | 214 | 0 (0)| |
| 4 | TABLE ACCESS BY INDEX ROWID| Table | 1 | 200 | 0 (0)| |