No Changes,No Alterations..Explain Plan Suddenly Changed !!!!

This is a very common question which i have always heard from the CLIENTS :-

“There has been no changes,no alterations , no new indexes , no parameter changes then why the HELL is this query running slow today??Did you check the explain plan.It was running good last month…WHY NOT TODAY??”

READ THIS –

http://richardfoote.wordpress.com/2010/02/16/how-does-an-execution-plan-suddenly-change-when-the-statistics-remain-the-same-in-limbo/

ENJOY

🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s