Archives of the TeradataForum
Message Posted: Tue, 22 Dec 2009 @ 09:15:27 GMT
Subj: | | Re: Problem using join index. |
|
From: | | Victor Sokovin |
| I faced similar issue. Optimizer did not use the JI when created on views. If I remember correctly we raised this concern this with
Teradata support and they have suggested for creation of JI directly on tables. | |
I don't think JI on views were ever supported. I thought the OP meant something else: JI ( created on tables ) is used when the normal query is
issued and is not used when the same query is encoded in a view.
BTW, the view was not mentioned in the original posting, so mentioning it was a useful clarification. DDL would be even more useful to avoid
confusion.
Just to make it clear: we are not after the original production DDL with hundreds of columns which have no relevance for the question. The
simplest test case in which the problem still exist would be ideal. Readers don't need to browse through pages of DDL, company's secrets are
protected but the readers would still be able to try and reproduce the case on their systems or would simply be able to understand what is
actually involved in the question.
Victor
|