Category Archives: Teradata

Teradata Database Object Summary

In my previous blog post I showed how to build an Object Catalog of your Teradata data warehouse. Trouble is even on moderately sized systems your Object catalog could result in tens of thousands of rows. One of my object … Continue reading

Posted in Databases, Teradata | Tagged , , | Comments Off

Building a Teradata Object Catalog

Recently I was asked to provide an inventory of a production Teradata system that included a list of all user created objects and as much information about the objects that I could gather included perm space usage, row counts, and … Continue reading

Posted in Databases, Teradata | Tagged , , | 8 Comments

Teradata Routine Maintenance: Perm Space History

A user over at TeradataQuestions recently asked a if there was a table in Teradata that allowed you to track the growth of tables or databases over time. The short answer to this question was no. The data dictionary tables … Continue reading

Posted in Databases, Teradata | Tagged , , | 6 Comments