Re: How to form an efficient Join query with more than 3 tables...?

From: John O <john_at_xxxzeitgeist.cix.co.uk>
Date: Tue, 16 Nov 1999 13:53:32 +0000
Message-ID: <383161DC.DFF2A588_at_xxxzeitgeist.cix.co.uk>


p.s.
[Quoted] 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.
Received on Tue Nov 16 1999 - 14:53:32 CET

Original text of this message