Versions Compared

Old Version 3

changes.mady.by.user Ashoat Tevosyan

Saved on

compared with

New Version 4

changes.mady.by.user Unknown User (gregdingle)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When the user issues that command, he may or may not specify the partition specs. If the user doesn't specify any partition specs, statistics are gathered for the table as well as all the partitions (if any). If certain partition specs are specified, then statistics are gathered for only those partitions. When computing statistics across all partitions, the partition columns still need to be listed.

Examples

Suppose table Table1 has 4 partitions with the following specs:
*Partition1: (ds='2008-04-08', hr=11)
*Partition2: (ds='2008-04-08', hr=12)
*Partition3: (ds='2008-04-09', hr=11)
*Partition4: (ds='2008-04-09', hr=12)
and the user issues the following command:

...