| sort unique problem [message #167257] |
Wed, 12 April 2006 03:15  |
hypnotoad
Messages: 2
Registered: April 2006
|
Junior Member |
|
|
hi
i have a problematic query, running differently on the test and production servers.
the query is using the same access path on both servers,
the only the difference is that the last phase of it - the sort unique is taking 2 hours on the production server and 2 minutes in on the test server
both servers has about the same memory configuration and workload, the data volume is the same (imported the data to the test server)
how can i speed up this sort?
(running oracle 9.2)
thanks
|
|
|
|
|
|
| Re: sort unique problem [message #167577 is a reply to message #167288] |
Fri, 14 April 2006 02:07  |
hypnotoad
Messages: 2
Registered: April 2006
|
Junior Member |
|
|
the problem is the sort unique, this adds about 2 hours
and it's only 5m rows to sort
(the query cannot be altered)
SELECT STATEMENT, GOAL = CHOOSE
_VIEW
__SORT UNIQUE
___UNION-ALL
____NESTED LOOPS OUTER
_____TABLE ACCESS FULL TABLE__1
_____TABLE ACCESS BY INDEX ROWID TABLE_0
______INDEX RANGE SCAN INDEX_ON_TABLE_0
____NESTED LOOPS OUTER
_____TABLE ACCESS FULL TABLE__0
_____TABLE ACCESS BY INDEX ROWID TABLE__1
______INDEX RANGE SCAN INDEX_ON_TABLE_1
[Updated on: Fri, 14 April 2006 02:08] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
