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

Originally posted on Richard Foote's Oracle Blog:
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 have been… Continue reading How Does An Execution Plan Suddenly Change When The Statistics (And Everything Else) Remains The Same ? (In Limbo)

Scotland, get ready to fight

Originally posted on Stephen McLeod Blythe – Clicky Steve:
Earlier today, we woke up to the terrible realisation that the UK had narrowly voted to leave the European Union. This was an outcome that I ultimately expected, but facing the stark reality of the situation has still left me feeling numb, and in shock. Opening my eyes to see ‘Nigel Farage declares independence day’ and… Continue reading Scotland, get ready to fight