This article contains all the useful gather statistics related commands.

1. Gather dictionary stats:

2. Gather fixed object stats:

3. Gather full database stats:

4. Gather schema statistics:

5. Gather table statistics:

6. Gather stats for single partition of a table:

7. Lock/unlock statistics:

8 . Delete statistics:

8. Setting statistics preference:

9 . Deleting preferences :

10 . Publish pending statistics:

11. Delete pending statistics:

12. Upgrade stats table:

13. View/modify statistics retention period:

14. create stats table:

15. Export stats data:

16. Import stats table data:

17 . Few stats related sql queries: