Home » RDBMS Server » Performance Tuning » Whether Statistics upto date or not (oracle 9i)
Whether Statistics upto date or not [message #357175] Tue, 04 November 2008 03:48 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
I had an issue where I informed that statistics need to be gathered on tables /indexes in the new schema.But in reponse, it was said that the statists are gathered on a regular basis by scheduled jobs by the DBA.

I am finding a big difference in while taking count for the number of rows and num_rows in a table.

What I know is if statistics were uoto date then there will be no difference in the number of rows (count) and NUM_ROWS value.

Please let me know if I am wrong here.

Regards,
Oli

Report message to a moderator

Re: Whether Statistics upto date or not [message #357194 is a reply to message #357175] Tue, 04 November 2008 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on how the statistics were computed or estimated and the activity on your table.
LAST_ANALYZED column gives you when the statistics were last gathered.

Regards
Michel

Report message to a moderator

Re: Whether Statistics upto date or not [message #357202 is a reply to message #357194] Tue, 04 November 2008 04:58 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Thanks Michel.

Report message to a moderator

Previous Topic: Packaged procedure tuning
Next Topic: select does a full table scan. 130.000.000 rows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 04:43:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.