How to optimize server for cartesian join?
From: Jack <none_at_INVALIDmail.com>
Date: Thu, 31 Jan 2008 07:02:02 GMT
Message-ID: <Kneoj.40$Ll.3@read4.inet.fi>
Date: Thu, 31 Jan 2008 07:02:02 GMT
Message-ID: <Kneoj.40$Ll.3@read4.inet.fi>
We have business need to do some countings.
It is using MERGE JOIN [CARTESIAN], it will go fast with 10.000 count, but with 200.000 end sum it will take very long time. It is using Reports 6i (a bit old;)
It does utilize very complez views etc, and plan is long as you would
assume.
I am not going to send plan.
One solution would be redesing it, but not quite sure it would help.
Server is 9.2.0.8 (multi prosessor, quite good one), parameters are now very
small, and
not optimized.
Is there some good parameters in server side which could help? Received on Thu Jan 31 2008 - 01:02:02 CST