RE: 10g Performance: its crawling

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of MVR Sent: Friday, December 29, 2006 3:53 AM
To: John Kanagaraj
Cc: oracle-l
Subject: Re: 10g Performance: its crawling  

• Well, I know the SQL. I have rebuilt one of index(reclaimed more than 100M, and now size of the index is 279M)... I will see if that makes any difference..

Rebuild of indexes will not improve performance in any ways, though it may reduce a bit of PIO for operations like Index FFS, Range Scan. Check the plan, it might be using a sub-optimal path. Are statistics uptodate and of course have u collected histograms?    

Rgds

Abhay

--
http://www.freelists.org/webpage/oracle-l