Re: Index clustering and performance

Posted in 1996

Billy Wheeler — 8 Oct 1996 03:58:05 -0400 — source: Informix-list mailing list archive (1991-1998)

> > I remember a thread from long ago . . . can you refresh my memory? > > My database performance is declining, and my DBA wants to dump and reload > the database, hoping that will help. Do you ever shutdown and restart OnLine? That could help. Also, try UPDATE STATISTICS. There are several options with UPDATE STATISTICS, best to RTFM. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | Oracle isn't the answer. Oracle is the question, and the answer is "no". | +------------------------------------------------------------------------------+