Skip to content

Something about Execution plan in Oracle

February 17, 2010

If you ever wondered why all of sudden execution plan for your queries have changed; even though you have not put any Oracle/System Patches nor upgraded the version nor collected statistics nor created new indexes etc i.e. Inshort everything else remained same except the addition or modification to the data, then you need to read this excellent article written by Richard Foote .

No comments yet

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

%d bloggers like this: