This course addresses the tuning and performance functionsof the Teradata Database, and provides an in-depthexamination of the processes and procedures to follow oncea Teradata Database has been implemented and is inproduction. Troubleshooting performance issues and tuningthe various system components for maximum performanceare key topic areas. The EXPLAIN facility is introduced andits use in analyzing query performance is explored. Topicsinclude: locks and deadlocks, Teradata join strategies,collecting statistics, Join Indexes, Hash Indexes.
Teradata Physical Database Tuning
Zahraničí
anglicky
