Re: QUERY TUNING

From: Helma <helma.vinke_at_hotmail.com>
Date: Thu, 18 Dec 2008 06:52:44 -0800 (PST)
Message-ID: <a417f1fd-ca50-4775-a510-9efe52fa415e@t39g2000prh.googlegroups.com>

to: Mladen Gogala

For this SQL i don't think that running the system statistics will make any difference. But not running system statistics is just a bad idea, don't you agree?

About the histograms, they work nicely on skewed data. For me, it's just applying the idea of feeding the optimizer with as much relevant info as possible and see if the problem is still there. First clean up your shop before the real work starts.

There may be a connection with the shop i am currently working on. They refuse to update their 3 year old statistics because ' that may lead to even more performance problems' , and they prefer to create new indexes when plan instability hits them again.

So i am currently in a mantra of ' take care of your statistics first' before trying anything else first. Received on Thu Dec 18 2008 - 08:52:44 CST

This message: [ Message body ]
Next message: Ed Prochak: "performance of updates"
Previous message: sybrandb: "Re: Turning off DML commit when session is exited or disconnected"
In reply to: ddf: "Re: QUERY TUNING"
Next in thread: Mladen Gogala: "Re: QUERY TUNING"
Reply: Mladen Gogala: "Re: QUERY TUNING"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message