All Forums Database
manib0907 61 posts Joined 04/15
26 Jun 2015
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?

Regards,
Mani

Cheers, Mani
dnoeth 4628 posts Joined 11/04
27 Jun 2015

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) 

Dieter

You must sign in to leave a comment.