Re: How to form an efficient Join query with more than 3 tables...?
From: <masyedkasim_at_hotmail.com>
Date: Tue, 16 Nov 1999 14:57:06 GMT
Message-ID: <80rrbv$1fv$1_at_nnrp1.deja.com>
Date: Tue, 16 Nov 1999 14:57:06 GMT
Message-ID: <80rrbv$1fv$1_at_nnrp1.deja.com>
Thanks John.
I will try this out.
In article <383161DC.DFF2A588_at_xxxzeitgeist.cix.co.uk>,
John O <john_at_xxxzeitgeist.cix.co.uk> wrote:
> p.s.
> You may also need to get rid of the NVL on the date since this will
> prevent any index on the date being used. For example, instead of
> allowing the date to be null, populate it with a minimum or maximum
> date, e.g.
> TO_DATE(1,'J') is the minimum date.
>
> --
> Regards,
> John.
> p.s. remove xxx from the email address if you want to reply.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 16 1999 - 15:57:06 CET