Re: Query with Bind variables hangs but hard coded literals works fine

That is precisely why I advised /*+ gather_plan_statistics */ hint. The only way to figure out what differences are important is to compare e-rows with a-rows and see where the estimates are being wrong. Also, I normally don't trust the customer statistics.

On 11/26/19 7:45 AM, Andy Sayer wrote:
> There's so many differences in these plans that it's hard to pick out
> what's important, that and the plans we've got to look at may have no
> relation to the real plans means we are just stabbing in the dark. I
> suggest you get the real execution plans with row source statistics so
> we can see what's really important here.
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l