Re: order by / sorting performance issue

There is a sql script on ixora.com.au to check to see if you are hitting the disk for the sort. Called disk_sorts.sql Sorts in memory will be must faster than sorts to disk Run the script and modify the sort_area_size to make sure most sorts run in memory (provided you have enough memory).

The other choice, overkill perhaps :) might be to use an index-organized table, organised on the order by column. or create an index which will satisfy the query, the optimiser could then choose to perform a full index scan...

We are grasping at straws without seeing the SQL, the indexs on tables, the sort_area_size etc.

Have Fun

p.s. noticed there is few people from Aus. Is work slow eh?

--
An Oracle DBAs undocumented init.ora parameters


_OVERCOME_POOR_DESIGN = TRUE

_DISABLE_BAD_PERFORMANCE = TRUE


An Oracle DBAs undocumented init.ora parameters


_OVERCOME_POOR_DESIGN = TRUE

_DISABLE_BAD_PERFORMANCE = TRUE


An Oracle DBAs undocumented init.ora parameters


_OVERCOME_POOR_DESIGN = TRUE

_DISABLE_BAD_PERFORMANCE = TRUE


Posted via dBforums
http://dbforums.com