Archives of the TeradataForum
Message Posted: Thu, 25 Dec 2009 @ 02:04:50 GMT
| Subj: | | Re: Writing efficient Teradata SQL |
| |
| From: | | Rob Paller |
There is a performance optimization manual available as part of the online manuals. A lot has to deal with the use of primary indexes for
access, statistics on join columns and columns used for criteria. Row redistributions must be done for joins between two columns that are not
hashed to the same AMP. When dealing with very large tables (100's of millions) partitioning the primary index or even join indexes can be used to
help improve performance.
Not knowing your exact problem leads to over generalized errors.
| 
