Re: FW: Index usage

From: "BBI Edwin Punzalan" <edwin@bluebamboo.ph>


>
> Hi, what do you mean by increasing the statistics on the date column?

alter table chatlogs alter column date set statistics 300;
analyze chatlogs;

> > > Our version is 7.2.1
> >
> > upgrade time ?
>
> We never had any upgrade on it.

7.2 is a bit dated now that 8.0 is in beta

if you want to stay with 7.2, you should at least upgrade
to the latest point release (7.2.6 ?), as several serious bugs
have been fixed

gnari