Search

OakieTags

more tags

Who's online

There are currently 0 users and 38 guests online.

Recent comments

Affiliations

Home » Monthly archive

April 2010

Daylight Saving Time Causes Performance Issues!

Submitted by chenshap on Fri, 2010-04-02 02:13

Since I’m starting employment with Pythian on Monday, this is the last technical post that is exclusive to this blog. Future technical tips, discoveries and stories will appear on the Pythian blog, and either copied here or linked to from here. BTW. I already made my first post in the Pythian blog today, as the editor of the Log Buffer – and I’m not even an employee yet :)

So, lets end this with a bang. Real life story on how Daylight Saving Time caused one query to take twice as long as before! And its not even an April Fools joke :)

Analyze This – 2

Submitted by Jonathan Lewis on Thu, 2010-04-01 20:58

If you’ve run the scripts from Analyze This, I hope you found that the query gave you two different execution plans. This is my output from the test (with a little cosmetic tidying):

=============
Using Analyze
=============

Execution Plan
----------------------------------------------------------
Plan hash value: 1838229974

-------------------------------------------------------------------
| Id | Operation | Name | [...]