 |
 |
Archives of the TeradataForum
Message Posted: Thu, 19 Nov 2009 @ 11:02:41 GMT
| Subj: | | Re: Index of a Derived Tables. |
| |
| From: | | Victor Sokovin |
| | Does Teradata create index for a derived table? if yes can we find the index column name/names and can we change it as per our requirement
for better performance ? | |
Derived table? It is an in-spool / in-memory object created by Teradata during query execution. It is internal and I don't think user can have
any control over it. If you want a better performance consider a different derived table. Experiment!
Victor
| |
