Home » RDBMS Server » Performance Tuning » Collecting stats (oracle 10.2.0.1.0 - windows XP)
Collecting stats [message #496924] Thu, 03 March 2011 03:36 Go to next message
muktha_22
Messages: 527
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

Re: Collecting stats [message #496938 is a reply to message #496924] Thu, 03 March 2011 04:14 Go to previous message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because statistics on the index are gathered.

Regards
Michel

[Updated on: Thu, 03 March 2011 04:15]

Report message to a moderator

Previous Topic: Dynamic SQL performance
Next Topic: Tunning the query and 4000-5000 parameter in IN clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 05:54:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.