Re: Estimating effectivity of performance improvement measures

From: hpuxrac <>
Date: Thu, 27 Nov 2008 02:07:16 -0800 (PST)
Message-ID: <>

On Nov 26, 2:32 pm, Palooka <> wrote:


> > I think you have a better handle on the issues than most people.  It's
> > difficult to accept that the problem may have so many variables that
> > reactive empirical testing is the only way to go.  Jonathan Lewis has
> > published some on attempting to figure out if the data layout would
> > benefit from reorganization, sometimes the data quickly goes back to
> > it's old shape.  I have at least one table/report combination that
> > runs noticeably slower (7 hours v. 5 hours) on newly added data
> > apparently because of the strangely skewed distribution on entry.
> You have reports which take 5-7 hours? Reorganising tables and
> rebuilding indexes is not going to help much.
> Redesign, introduce some redundancy through mviews, set up a data mart
> or something.

Well actually that was Joel throwing in the long running reports ( not the OP who is considering some reorgs/rebuilds ). Received on Thu Nov 27 2008 - 04:07:16 CST

Original text of this message