How To Gather Statistics of a Table Partition(Update Partition Statistics)

 

When the table is large in Partitioned tables, the statistical update process is very long. Although the information we query will take place in several partitions, the query may not result because the table statistics are old.

We can get results in a much shorter time by gathering the relevant partition statistics(update partition statistics) as follows and by specifying the partition in our query rather than the whole table.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *