Query tuning
Hi,
I have a database in 10.2.0.3 and i have observed that in an identical query when the difference is of only ENTER is causing the performance difference :-
Good run :-
=========
select sub_txn_id, to_char(posted_date,:"SYS_B_0"), action,
to_char(sub_txn_date,:"SYS_B_1")
from
VI_SUB_TXN_T where sub_txn_id in (select min(b.sub_txn_id) from VI_SUB_TXN_T
a, vi_sub_txn_t b where a.sub_plan_id = b.sub_plan_id and a.sub_txn_id=
:"SYS_B_2" and b.sub_txn_id > :"SYS_B_3" and b.action in (:"SYS_B_4",
I have a database in 10.2.0.3 and i have observed that in an identical query when the difference is of only ENTER is causing the performance difference :-
Good run :-
=========
select sub_txn_id, to_char(posted_date,:"SYS_B_0"), action,
to_char(sub_txn_date,:"SYS_B_1")
from
VI_SUB_TXN_T where sub_txn_id in (select min(b.sub_txn_id) from VI_SUB_TXN_T
a, vi_sub_txn_t b where a.sub_plan_id = b.sub_plan_id and a.sub_txn_id=
:"SYS_B_2" and b.sub_txn_id > :"SYS_B_3" and b.action in (:"SYS_B_4",
0