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>
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