Search

OakieTags

more tags

Who's online

There are currently 0 users and 27 guests online.

Recent comments

Affiliations

Home

Index Access Path

How Does An Execution Plan Suddenly Change When The Statistics (And Everything Else) Remains The Same ? (In Limbo)

Submitted by Richard Foote on Tue, 2010-02-16 13:52

I’ve slipped this post in as there have been a number of discussions recently on how execution plans have changed while nothing else appears to have changed in the database. How can an execution plan suddenly change when no one has made any changes to the database ?   By no changes, it means that there [...]