Database Tuning (MOSC)

MOSC Banner

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center