Re: Problem with fragmentation by expression
pablof@my-dejanews.com wrote:
>
> In article <Pine.UW2.3.96.990112101650.16436C-100000@hercules>,
> Rob Wilson <rwilson@ntsource.com> wrote:
> > On Tue, 12 Jan 1999 pablof@my-dejanews.com wrote:
> >
> > > Hi all:
> > > I'm running IDS 7.30 FC5 on DEC Alpha8200. I've got a problem with a table:
> > > create table valores(
> > > ejercicio decimal(2,0),
> > > recibo decimal(7,0),
> > > codigo_cobro decimal(1,0),
> > > ...)
> > > fragment by expression
> > > (codigo_cobro=0) in dbs3,
> > > (codigo_cobro!=0) in dbs2
> > > extent size 500000 next size 50000 lock mode row> > > ......
> > > create unique index i_valoreskey on valores
> > > (ejercicio,recibo,codigo_cobro)[SNIP]
> As you can see I cannot
> eliminate any fragment. I think there must be a problem with 7.30 because I
> could eliminate fragments when i tried it on 7.23. This is a big problem for
> us because this table is the most important table of our environment.
Have you updated statistics to high or medium on the fragmentation and
index columns?
Art S. Kagel