how to tune a view?
639811Nov 11 2008 — edited Nov 11 2008Hi all,'
yesterday i found one query which is taking long time. when i checked the explain plan for that query it shows for onr table cost is around 16132..
but in that query oracle its not using the table rather than table oracle itself created i guess inline view. so they are trying to fetch the values from that. is there any way to tune the view? or i shall remove the view and mentioned the table name wil it works?
Regards
M.Murali..