Explain Plan based on stats


Explain Plan based on stats

hi All,

I have question on the explain plan being generated for a query. If there is a mismatch in the unique values in the table and unique values that help stats shows(table has less count than that the stats show), then what will be the impact ? Will the plan provided by the optimizer not an appropriate one?
Is the plan provided accurate only when the values match?

Tags (1)
Senior Apprentice

Re: Explain Plan based on stats

Hi Mani,

of course the plan might be bad if stats are wrong (wrong = orders of magnitude).

If you know that stats are outdated you might recollect them and simply check Explain before and after if there's a different plan (not only different estimates)