last analyzed "dba indexes" view not up to date
755353Nov 11 2011 — edited Nov 28 2011Hi
Oracle decided not to collect stats on one large table ( last analyzed is 3 month out of date), this is huge table half a billion entry and thousand being added every day .
I understand that oracle gathers stats only if there are significant changes to the underlying table. I can’t do a select count on the table to see how much entry we have now ( select count(*) takes 7 hours to run)
My question is since stats are not up to date, will it cause any issues?
Will it case oracle to select wrong plan?
We do have performance problems and want to ensure this is not the cause
Thank you