CODEWITHSUNDEEP
postgresql
Pranav
Pranav

Reputation: 21

How to write the PostgreSQL query for "Update Statistics" for a given table?

Example: For MSSQL we use "UPDATE STATISTICS table_name".

What can we use for PostgreSQL?

Upvotes: 2

Views: 3191

Answers (1)

user330315
user330315

Reputation:

To update the statistics of a table, you use the ANALYZE command.

analyze table_name;

Upvotes: 5

Related Questions