|
|
Archives of the TeradataForum
Message Posted: Fri, 12 Sep 2003 @ 18:01:46 GMT
Subj: | | Re: Will an Index be used with Derived Tables |
|
From: | | Dieter Noeth |
Walter, Todd A wrote:
| Sorry Michael but this statement is not correct. The column order in the derived table is irrelevant (unlike the rule for CREATE
TABLE where if no PI is specified TD defaults to the first column). | |
Thanks for the clarification, Todd.
I heard that rumour several times and always answered similar. I just didn't want to be too rude, as i didn't write a book, yet ;-)
Dieter
| |