Re: Wrong execution plan
Date: Wed, 10 Jun 2009 15:26:26 +0100
Just two possibilities to quickly rule out before all the more complex possibilities are debated:
- check that the datatypes of the PL/SQL variables are all appropriate and no implicit datatype conversions are taking place - I expect pos_num is a NUMBER; is l_tmp_num1 also?
- check that the there's no NLS conversion issues (language or character set)
2009/6/10 Joerg Jost <joerg.jost_at_unitrade.com>
> Hi list,
> the following SQL leads to an execution plan which is absolutely wrong.
> SELECT pos_komnr
> FROM po
> WHERE pos_art = l_tmp_art1
> AND pos_num = l_tmp_num1
> AND pos_pos = l_tmp_pos;