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 -> Problem with indexes

Problem with indexes

From: Katarina Laclavikova <klaclavikova_at_europe.com>
Date: 3 Nov 2003 07:25:29 -0800
Message-ID: <bbd8a2fb.0311030725.25c3ae98@posting.google.com> 





Hi all


Last weekend, l was move index tablespace to another disk. After that,
application running more slower.


It doesn't use some indexes. I was rebuild indexes, collect statistics
and application is still running slowly.
( SELECT which was running 20 sec, now is running 1 hour ) 



Any comments or suggestions appreciated. 



Thanks


Katarina




Katarina Laclavikova


klaclavikova_at_europe.com
Received on Mon Nov 03 2003 - 09:25:29 CST












Original text of this message













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