How is the statistics in PostgreSQL updated?
- 1 Answers
- 2568 Views
- I also Faced
- E-Mail Answers
How is the statistics in PostgreSQL updated?..
Answer / madhub
Vacuum with the option Analyze is used to update statistics in Postgresql
VACUUM ANALYZE ; is the syntax.
| Is This Answer Correct ? | 0 Yes | 0 No |
More Postgre Interview Questions
How do I start postgresql on windows?
What is pg server?
How to create local server in postgresql?
How secure is postgresql?
Is foreign key required?
How does db indexing work?
What is schema in reading comprehension?
What command do you type to exit the postgresql console application?
Compare ‘postgresql’ with ‘nosql’?
How do I change primary key in pgadmin?
Explain about pgadmin?
Is postgresql a relational database?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
