I gave a presentation at the Teradata Partners Conference last week on the fundamentals of collecting statistics, where I touched briefly on the rules behind confidence levels. I’m using this article to go into further depth, and offer you more examples of how these confidence levels come about. If you look at query plans much, I’m confident you’ll find something of interest in this article.

Here are a couple of helpful links in Teradata Relationship Manager (TRM).  These allow you to see all of the security privileges and user groups assigned to the logged in user, as well as a report of the TRM version and detailed environmental information.

The Teradata Agile Analytic Cloud allows business users and developers to easily allocate an elastic data mart (i.e. a database) inside the Teradata System. Using an on demand self service portlet (the Elastic Marts Builder portlet), the user can create a database, upload comma separated values (.CSV) data, and begin analysis – all within 5-10 minutes.

We all know the benefits of identifying and fixing badly performing workloads. Many sites use the common method of identifying the top n highest consuming or skewed queries (often the same queries) and fixing those.