Execution Plan report very low cost
Dear all,
I have an SQL run agains EBS GL Schema which analyzed as bellowing.
Although I try update dictionary of GL_DAILY_BALANCES and Index GL_DAILY_BALANCES_N7_EXT , the execution plan still caculate as only 1 row return. Therefore, Cost and Time is very low and DB do not execute the SQL in parallel mode.
In fact, the query return more than 100k rows, cost of the run is around 20 mins.
Please advice how to correct execution plan estimation.
Some more fact:
GL_DAILY_BALANCES and GL_DAILY_BALANCES_N7_EXT has more than 400k lines.
The full query is bellowing