Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2004 @ 09:49:19 GMT


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


Subj:   Views and Join Indexes
 
From:   Matthew Winter

Hi,

Whilst having problems getting the optimiser to use a Join Index, I thought of a way which could be used to guide the optimiser into using a Join Index.

The following addition would be made to the CREATE VIEW command.

     CREATE VIEW view_name AS JOIN INDEX join_index_name;

This command would effectively create a view using the SELECT clause from the specified Join Index, but it would also add an entry into the appropriate DBC table, that this view is associated with the named Join Index.

Then when the optimiser calculates an execution plan for a query which includes this view, it would ensure that priority is given to the use of the named Join Index.


Regards

Matthew Winter



     
  <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: 27 Dec 2016