Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with indexes
"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 UkReceived on Tue Nov 04 2003 - 05:53:16 CST