gather index stats

[zubair]

I have ran dbms_stats.gather_index_stats('schemaname','indexname');
i want to see the output from where i can get please help me.

[ErmanArslansOracleBlog]

What kind of output do you expect?

there are no output produced by dbms_stats.

It will only give you errors if it fails.

2015-11-18 15:23 GMT+02:00 zubair [via Erman Arslan's Oracle Forum] <[hidden email]>:

I have ran dbms_stats.gather_index_stats('schemaname','indexname');
i want to see the output from where i can get please help me.

---

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-tp449.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[zubair]

ok fine thanks.
and if we  want to analyize index for performance issu then how can i

[zubair]

ok fine thanks.
and if we  want to analyize index for performance issu then how can i

[ErmanArslansOracleBlog]

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.

18 Kas 2015 18:12 tarihinde "zubair [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

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

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML