Home » RDBMS Server » Server Administration » analyze table command
analyze table command [message #52643] Sat, 03 August 2002 11:51 Go to next message
Jhon Bruinsma
Messages: 13
Registered: May 2002
Junior Member
Hi, maybe someone can help me here.
If I use the command 'ANALYZE TABLE tablename COMPUTE STATISTICS;', are then all of the associated indexes of this table also analyzed?
Thanks in advance!

Report message to a moderator

Re: analyze table command [message #52659 is a reply to message #52643] Mon, 05 August 2002 09:41 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Yes.

Report message to a moderator

Previous Topic: Re: Total memory used by a database
Next Topic: Start OEM (stress)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:42:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.