Database Tuning (MOSC)

MOSC Banner

results return slowly when use SUM and ORDER BY

edited May 30, 2012 1:31PM in Database Tuning (MOSC) 9 commentsAnswered
Hi,

    I have a table with about 2 million records. This table has a column (call col_A) and it's foreign key . I create index on it.

    If I SELECT from this table, all works are normal. But when I SELECT and SUM with GROUP BY(col_A), it is very slowly !

    From askTom, I can increase sort_area_size to my sql faster. I do not try this but I think if I set work_area_size_policy=AUTO, Oracle will increase sort_area_size to sort data. And if increase value, it can effect to other sessions in DB ?

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