Optimize a simple query....

From: Janakies Louca <janakiel_at_absa.co.za>
Date: Thu, 16 Mar 2000 12:07:59 -0800
Message-ID: <38d0b1ad$0$44102@hades.is.co.za>

Hi ppl,

Please help, I need to optimise this query to run faster (18 hours currently) on a 12 Node Partitioned machine....

SELECT A.FIELD

from     A_TEMP A,
           B_TEMP B
WHERE   A.FIELD  = B.FIELD AND
               A.A_DATE >= B.B_DATE

ORDER BY A.FIELD) I know that using a partition is much faster (1 hour) but I need to access data sitting accross all 12 partitions...Any Ideas ???

Thanx,
Janakies Received on Thu Mar 16 2000 - 14:07:59 CST