Check clustering factor of the index. Also check if your index is used properly by your queries.. Read performance tuning and richard foote's index index internals documents.
ok fine thanks.
and if we want to analyize index for performance issu then how can i
If you reply to this email, your message will be added to the discussion below:http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/gather-index-stats-tp449p452.htmlTo start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML
Free forum by Nabble |