Index creation - Execution plan
Dear Experts,
We are on Database version 19.17
Really not sure whether creating an index helps? How can we deal with this sql like creating any extended statistics? Please guide.
SQL ID: 2vckthp9pbzyz Plan Hash: 3844545154 SELECT COUNT(*) FROM XXTTD_BU_SCC_MAPPING WHERE ERP_UNIT_CODE=:B3 AND ERP_SUB_UNIT_CODE=:B2 AND ERP_SUB_COST_CENTER=:B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 789032 27.05 27.05 2 2 1 0 Fetch 789032 588.29 590.87
0