OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Collecting stats (oracle 10.2.0.1.0 - windows XP)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Collecting stats [message #496924]

Thu, 03 March 2011 03:36

muktha_22
Messages: 337
Registered: December 2009

Senior Member

Hi All,

please clear my below doubts.

1) I made a composite index.
2) without collecting statistics, i had run AUTOTRACE.
It shown me FULL TABLE SCAN.

3) Then I had collected the stats and ran Autotrace,
Still it shows FULL TABLE SCAN only.

4) But when I dropped and recreate the index, then it shows me RANGE SCAN.

Why, we need to drop and recreate the index?

Regards:
Muktha

Report message to a moderator