-----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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