RE: 10g Performance: its crawling

  • From: "Abhay Suresh Kulkarni" <AbhKulkarni@xxxxxxxx>
  • To: <yoursraju007@xxxxxxxxx>, "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
  • Date: Fri, 29 Dec 2006 12:06:35 +0530

-----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

Other related posts: