Re: Tuning By cardinality Estimates
- From: 조동욱 <ukja.dion@xxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- Date: Fri, 6 Mar 2009 20:45:34 +0900
Because Oracle's basic assumption is not realistic?
Would you post both results(plan statistics) of nested loops version and
hash version?
================================
Dion Cho - Oracle Performance Storyteller
http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)
================================
On Fri, Mar 6, 2009 at 8:34 PM, hrishy <hrishys@xxxxxxxxxxx> wrote:
>
> 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
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
