Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Does ANALYZE tables/indexes need to be executed periodically ?!

Does ANALYZE tables/indexes need to be executed periodically ?!

From: Raymond K.W. Lau <raymdlau_at_hk.super.net>
Date: 1997/12/20
Message-ID: <67ga3q$bh9$1@tst.hk.super.net>#1/1 







We have a 7.3.3 db installed on a Sun Server. The optimizer_mode is set to
CHOOSE. When we try to execute some SQL statements ( not well tuned ), the
performance is extremely slow. But after ANALYZE all tables and indexes, we
get all the results on the fly.



Thanks in advance !



Raymond
Received on Sat Dec 20 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US