Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Dec 2009 @ 09:15:27 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023