Using the print_progress parameter

The syntax for print_progress is:

• update index statistics:

  update index statistics
  table_name [[partition data_partition_name] |
  . . .
  [, print_progress = int]
  

• update all statistics:

  update all statistics
  table_name [partition data_partition_name]
  . . .
  [, print_progress = int]
  

• update statistics

  update statistics
  table_name [[partition data_partition_name]
  . . .
  [, print_progress = int]
  

Where:

• 0 – (the default) disables print_progress to not display any progress messages

• 1 – enables print_progress to display progress messages

This example shows the progress messages when update statistics is run on table bigtable:

update statistics bigtable with print_progress=1

Update Statistics STARTED.
Update Statistics index scan started on index 'bigtable_NC1'.
Update Statistics table scan started on table 'bigtable' for summary statistics.
Update Statistics FINISHED.

This example shows the progress messages when update index statistics is run on table bigtable:

update index statistics bigtable with partial_hashing, print_progress=1

Update Statistics STARTED.
Update Statistics index scan started on index 'bigtable_NC1'.
...It is using existing index scan to hash minor column 'a2' (column id = 2).
...Column 'a2' (column id = 2) is moved from hashing to sorting.
Update Statistics table scan started on table 'bigtable' for summary statistics.
Update Statistics table scan started on table 'bigtable'.
...Sorting started for column 'a2' (column id = 2).
Update Statistics FINISHED.

This example shows the progress messages when update statistics ... with hashing is run on table bigtable:

update statistics bigtable (a1), (a2), (a3) with hashing, print_progress=1

Update Statistics STARTED.
Update Statistics table scan started on table 'bigtable'.
...Column 'a3' (column id = 3) is picked as hash victim due to limited resource.
Update Statistics table scan started on table 'bigtable'.