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

Re: Problem with indexes

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 4 Nov 2003 11:53:16 -0000
Message-ID: <3fa7932c$0$250$ed9e5944@reading.news.pipex.net>


"Katarina Laclavikova" <klaclavikova_at_europe.com> wrote in message news:bbd8a2fb.0311030725.25c3ae98_at_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 )

An explain plan and the sql would help.

-- 
Niall Litchfield
Oracle DBA
Audit Commission Uk
Received on Tue Nov 04 2003 - 05:53:16 CST

Original text of this message

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