Re: Explain Plan irregularity

Thanks all for the replies,

There are other bind variables in my WHERE condition but it seems to be the date between bind variables that change my plan from hash joins (good) to nested loops (bad). And I don't seem to have that special hint in my bag-o-hints to change the plan back to hash joins.

Because I'm interested in only running a calendar month at a time, I'm going to try a function-based index on to_char(inv_date,'YYYY') || to_char(inv_date,'MM') and change my between condition to to_char(inv_date,'YYYY') || to_char(inv_date,'MM') = '200203'.

Tuning seems to be more of an art than an exact science.

~Bill

--
Posted via dBforums
http://dbforums.com