SQL query which is fetching data from five tables in Oracle 18.104.22.168.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.
Tags for this Thread
Click Here to Expand Forum to Full Width