Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Oct 2003 @ 15:18:40 GMT


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


Subj:   Index Use
 
From:   Hassinger, Bill

After receiving complaint of slow response, I found that queries with a single value against a NUSI were not using the index when querying using the view, but did use the index when querying directly against the table. Statistics did exist. The view used a Select * to the table, but this is similar to most of our views and I don't believe a factor. The complaints also started a couple days after the table/index/view creation, so I don't know it some event caused the problem, or if it existed when the view was created.

Has anyone else experienced this anomaly? We are on V2R3.

Bill H



     
  <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