Here are your search results
In this article, we will show you how Block-Level Compression, Row-level partitioning, and the selected data block size of a table can affect performance and table size. For this demonstration, we need a test table on which we will make various changes to these settings. Our test table includes customer data and a cut-off date.
If you are looking to have in-depth knowledge on how your load utilities (or even DSA jobs) are running in your environment or investigating their performance, the DBQLogTbl is just the beginning. The DBQLogTbl does provide metrics for these utilities, but not as accurate and as abundant as what Teradata DBQLUtilityTbl can offer. What is
The Teradata DBQL Tables Query logging includes a variety of table/view combinations in the DBC database: DBC.DBQLOGTBL and DBC.QryLogV Saves one row per query with the aggregated key figures like the number of CPU seconds, number of IOs, and much more. DBC.DBQLStepTbl and DBC.QryLogStepsVThe individual steps of a query are saved here, including the important
What is a Teradata Query Band? The DBQL tables provide us with all the key figures we need to optimize queries. Because a Teradata system typically runs many thousands of queries per day, it is not easy to locate individual queries in the DQBL tables. It is, therefore, good practice to use the Teradata query
Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk your way through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing, and
Teradata Spool Space Introduction 4 Types of Teradata Spool Space IntermediateWill be released as soon as it is no longer needed. Intermediate Spool Space is required by derived subqueries, for example. The execution plan provides information about when spool space is released. OutputThe Output Spool Space holds the result of an SQL request. VolatileThey are
Types of Teradata Access Rights Teradata distinguishes between these four types of access rights: Implicit: The Teradata privileges of a user or database owning an object (“ownership privilege”) Explicit: The Privileges explicitly granted with the GRANT statement Inherited: The privileges inherited by being a role member Automatic: The privileges automatically granted by Teradata Owners and Creators Teradata distinguishes between creators and owners of database