Hi all,

SQL query which is fetching data from five tables in Oracle 11.2.0.1.0 on Linux 5 , taking double of the time to fetch the data before it used to take, i have gathered statistics of all tables by seeing the view dba_tab_statistics under that column stale_statistics , but no affect or impact of that, so could any one suggest me how to tune the SQL query step by step. i would appreciate a lot.

Thanks & Regards.