OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Statistics

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

Statistics [message #170597]

Thu, 04 May 2006 08:18

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi,

I'm confused with the ANALYZE database objects,schema & database concepts,Can anyone clear my doubts in layman terms,

1) What does the statistics mean here,what are the details will be gathered by it?

2) What is the difference between COMPUTE & ESTIMATE statistics?

3) How the statistics collected is helpful in improving database performance?

Thanks,
Gajini

Report message to a moderator

Re: Statistics [message #170599 is a reply to message #170597]

Thu, 04 May 2006 08:26

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

You read fast?

http://www.orafaq.com/forum/t/62790/68488/

You've just been pointed to the documentation (for the umpteenth time) Please read it, if you still have questions, read it again. Then post any questions

Report message to a moderator

Re: Statistics [message #170601 is a reply to message #170599]

Thu, 04 May 2006 08:32

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Some additional info:
http://blogs.ittoolbox.com/c/programming/archives/008055.asp

MHE

Report message to a moderator

Previous Topic:	How to create a new user from an existing user
Next Topic:	any troubleshooting advice??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:20:43 CDT 2024