Re: Optimize a simple query....

Insufficient information!
primary key?
indexes?
size of tables (as this is 'temp', they shouldn't be big heh) execution path of current query?

To mention a few.

Regards,

Sybrand Bakker, Oracle DBA

Janakies Louca <janakiel_at_absa.co.za> wrote in message news:38d0b1ad$0$44102_at_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 - 04:50:52 CST