Archives of the TeradataForum
Message Posted: Fri, 12 Sep 2003 @ 16:13:24 GMT
| Subj: | | Re: Will an Index be used with Derived Tables |
| |
| From: | | Theiss, Clifford |
Michael Larkins wrote:
| | The Teradata optimizer decides at run time whether or not to use an INDEX dependent on residual conditions being defined in the WHERE
clause and on columns specifying equality and a value (versus column=column join). | |
This statement APPEARS to be saying that Teradata WILL use a secondary index in this situation:
....
where TableX.SI_column = 'myvalue'
....
but will NOT use an SI in this situation:
....
where TableX.SI_column = TableZ.column
....
That's not true, correct? I assume I'm misreading this statement. Please clarify.
| 
