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

Home -> Community -> Usenet -> c.d.o.server -> Deleting statistics speeds up server?

Deleting statistics speeds up server?

From: Tom Dyess <tdyess_at_dysr.com>
Date: Wed, 29 Oct 2003 15:38:44 -0500
Message-ID: <fvudnfSkNonIuD2iRVn-jw@fdn.com> 





One of our clients is running Oracle 9.2.0 on AIX. Our application that runs
on oracle was dog slow on their box. They brought in a consultant in and he
deleted the statistics on the tables and indexes and it sped it back up
again. Doubting the remedy, our net admin, reanalyzed the tables and it was
slow again, then deleted statistics and it was again fast. Does anyone know
what would cause such an unintuitive response?



Tom Dyess


OraclePower.com
Received on Wed Oct 29 2003 - 14:38:44 CST












Original text of this message













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