RE: Tuning By cardinality Estimates
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 6 Mar 2009 11:34:50 +0000 (GMT)
Message-ID: <673670.17033.qm_at_web23701.mail.ird.yahoo.com>
Date: Fri, 6 Mar 2009 11:34:50 +0000 (GMT)
Message-ID: <673670.17033.qm_at_web23701.mail.ird.yahoo.com>
Hi Bhavik
Thanks for quick response,and correcting my understanding on the starts column.
Having understood the starts column and the cardinality calculation my question then would be why oracle is not using Hash Join and prefers a Nested Loop join It takes almost 8 minutes to complete the query with nested loops.If i use a use_hash hint it completes in 2 minutes
regards
Hrishy
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 06 2009 - 05:34:50 CST