performance issue with million record table
Posted on 2008-11-20
There is one table with 4Million rows, running one query is causing performance issue.
Please help on how to resolve it.
SQL> select count(*) from psp.psp_adjustment_lines_history
Below query is causing performance issue:
MAX (a.distribution_date) latest_distribution_date
FROM psp.psp_adjustment_lines_history a
GROUP BY a.summary_line_id
Operation Optimizer Cost Cardinality Bytes
SELECT STATEMENT ALL_ROWS 39746 140014 1680168
HASH(GROUP BY) 39746 140014 1680168
TABLE ACCESS(FULL) PSP.PSP_ADJUSTMENT_LINES_HISTORY
ANALYZED 31841 4193690 50324280
Please suggest how to increase the performance.