RE: Tuning By cardinality Estimates

From: hrishy <>
Date: Fri, 6 Mar 2009 11:34:50 +0000 (GMT)
Message-ID: <>

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


Received on Fri Mar 06 2009 - 05:34:50 CST

Original text of this message