Re: 11G Statistics Collection
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 16 Apr 2012 15:27:20 +0000 (UTC)
Message-ID: <jmhdoo$j13$1_at_solani.org>
On Mon, 16 Apr 2012 15:18:19 +0200, Robert Klemme wrote:
Date: Mon, 16 Apr 2012 15:27:20 +0000 (UTC)
Message-ID: <jmhdoo$j13$1_at_solani.org>
On Mon, 16 Apr 2012 15:18:19 +0200, Robert Klemme wrote:
> But that approach does not work if the distribution changes in a way
> that different plans are optimal at different times.
That approach works. Don't fix it if it ain't broken. If the SQL performs well, nail it down and go about the other stuff.
-- http://mgogala.byethost5.comReceived on Mon Apr 16 2012 - 10:27:20 CDT