Site icon Database Tutorials

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.

Exit mobile version