CapsuleCorpJX
IS-IT--Management
Is there a DBC table that holds the last time statistics was collected on a given table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DBC Table that holds statistics info?
- Thread starter CapsuleCorpJX
- Start date
- Status
RogerCruse
MIS
STATS information is held in one of two places, depending on whether its STATS for an index or a column.
I assume you'll want both.
The information is a little difficult to obtain from first principles but if you goolge for "HASHBUCKET SUBSTR" I'm sure you'll find what you're looking for.
I suggest you tweak this to something more useful for your own instance of Teradata and set this up as a VIEW.
Then use this within a batch script to automate STATS refresh on a regular basis.
Roger...
I assume you'll want both.
The information is a little difficult to obtain from first principles but if you goolge for "HASHBUCKET SUBSTR" I'm sure you'll find what you're looking for.
I suggest you tweak this to something more useful for your own instance of Teradata and set this up as a VIEW.
Then use this within a batch script to automate STATS refresh on a regular basis.
Roger...
- Status
Similar threads
- Locked
- Question