Plan d'exécution des update :
Sur CNT :
"Optimizer" "Cost" "Cardinality" "Bytes" "Partition Start" "Partition Stop" "Partition Id" "ACCESS PREDICATES" "FILTER PREDICATES"
"UPDATE STATEMENT" "ALL_ROWS" "2" "1" "55" "" "" "" "" ""
"UPDATE SOC1.CNP" "" "" "" "" "" "" "" "" ""
"TABLE ACCESS(BY INDEX ROWID) SOC1.CNP" "ANALYZED" "2" "1" "55" "" "" "" "" ""
"INDEX(UNIQUE SCAN) SOC1.CNP_IDX1" "ANALYZED" "1" "1" "" "" "" "" ""CODSOC"=100 AND "ACHVTE"='V' AND "NUMCNT"=:4 AND "TQOI"='501' AND "CODPRO"=:5" ""
Sur EVT :
"Optimizer" "Cost" "Cardinality" "Bytes" "Partition Start" "Partition Stop" "Partition Id" "ACCESS PREDICATES" "FILTER PREDICATES"
"UPDATE STATEMENT" "ALL_ROWS" "12" "1" "75" "" "" "" "" ""
"UPDATE SOC1.EVT" "" "" "" "" "" "" "" "" ""
"TABLE ACCESS(BY INDEX ROWID) SOC1.EVT" "ANALYZED" "3" "1" "27" "" "" "" "" ""
"NESTED LOOPS" "" "12" "1" "75" "" "" "" "" ""
"VIEW SYS.VW_NSO_1" "" "9" "1" "48" "" "" "" "" ""
"SORT(UNIQUE)" "" "9" "1" "92" "" "" "" "" ""
"NESTED LOOPS" "" "8" "1" "92" "" "" "" "" ""
"NESTED LOOPS" "" "7" "1" "68" "" "" "" "" ""
"TABLE ACCESS(BY INDEX ROWID) SOC1.EVE" "ANALYZED" "4" "1" "38" "" "" "" "" ""EVE"."DATEVE"<='20110816' AND ("EVE"."CODETA"='B' OR "EVE"."CODETA"='F' OR "EVE"."CODETA"='V') AND "EVE"."DATEVE">='20110629'"
"INDEX(RANGE SCAN) SOC1.W_EVE_IDX1" "ANALYZED" "3" "1" "" "" "" "" ""EVE"."CODSOC"=100 AND "EVE"."ACHVTE"='V' AND "EVE"."TYPEVE"='LIV' AND "EVE"."TYPTIE"='CLI' AND "EVE"."SIGTIE"='168859'" ""
"TABLE ACCESS(BY INDEX ROWID) SOC1.EVP" "ANALYZED" "3" "3" "90" "" "" "" "" ""
"INDEX(RANGE SCAN) SOC1.EVP_IDX1" "ANALYZED" "2" "3" "" "" "" "" ""EVP"."CODSOC"=100 AND "EVP"."ACHVTE"='V' AND "EVP"."TYPEVE"='LIV' AND "EVP"."NUMEVE"="EVE"."NUMEVE"" ""
"TABLE ACCESS(BY INDEX ROWID) SOC1.PRO" "ANALYZED" "1" "1" "24" "" "" "" "" ""PRO"."CODZN15"='217440127'"
"INDEX(UNIQUE SCAN) SOC1.PRO_IDX1" "ANALYZED" "0" "1" "" "" "" "" ""PRO"."CODSOC"=100 AND "PRO"."CODPRO"="EVP"."CODPRO"" ""
"INDEX(RANGE SCAN) SOC1.EVT_IDX1" "ANALYZED" "2" "1" "" "" "" "" ""EVT"."CODSOC"="CODSOC" AND "EVT"."ACHVTE"="ACHVTE" AND "EVT"."TYPEVE"="TYPEVE" AND "EVT"."NUMEVE"="NUMEVE" AND "EVT"."NUMPOS"="NUMPOS" AND "EVT"."NUMLIG"="$nso_col_6" AND "EVT"."NUMBLO"="$nso_col_7"" ""EVT"."NUMBLO"="$nso_col_7""
Partager