In SQL*Server it is called "UPDATE STATISTICS"

http://msdn2.microsoft.com/en-us/library/ms187348.aspx

 

Oracle tuning is a lot more fiddly:

http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci121
3646,00.html

 

 

________________________________

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Harpreet
Dhaliwal
Sent: Wednesday, May 23, 2007 10:49 AM
To: Postgres General
Subject: [GENERAL] Vacuum DB in Postgres Vs similar concept in other
RDBMS

 

Hi,

I was wondering if Vacuum DB concept in Postgres is really novel and
there's no concept like this in other RDBMS like oracle or sql server.
If at all other RDBMS have such a concept implemented, how good or bad
it is as compared to postgres's vacuum db concept. 

Any type of pointers would be highly appreciated.

Thanks,
~Harpreet

Reply via email to