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