Re: Statistics in Oracle server performance

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/08
Message-ID: <32D3C43B.739A@qrcsun.qrc.org>#1/1

Leong San Io Francisco wrote:

> I deleted the statistics analyzed from the tables and the server returns
> back to the same level of performance before. Are statistics really BAD in
> Oracle 7.2.2? The tables that we have are fairly static so we decided to put
> on them statistics, but I haven't thought that putting them would be so bad!

Indeed, you can try to change the OPTIMIZER_MODE or OPTIMIZER_GOAL instead of deleting the statistics from the table. Anyway, could you mind to point out whether you gain a poor or better results after using statistics ?

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Wed Jan 08 1997 - 00:00:00 CST