|
|
Archives of the TeradataForum
Message Posted: Thu, 14 Sep 2006 @ 15:21:37 GMT
Subj: | | Re: Guidelines for Join/ Hash Index |
|
From: | | John Graas |
| Are there any guidelines as to when to use Join, Hash Indexes to improve the performance of queries. Can Join Indexes be created during
execution of a SQL and dropped soon after the purpose is served. | |
I realize that this is a bit of a RT*M answer, but Chapter 12 of the Teradata "Database Design" manual has a nice write-up, with an index use
overview in Ch. 9.
jdg
www.jgraas.com
| |