Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Jan 2014 @ 13:23:31 GMT


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


Subj:   Re: Question on joining UPI with non unique SI
 
From:   Gregg, William

Hi Roopalini - the only way to influence the Optimizer for a given query is with statistics and indices.

So, there is no guarantee that the Optimizer will use the indices in the Explain Plan.

Also, keep in mind, Teradata is built to do table scans. If the number of rows is large enough, the Optimizer will not use an index to get the data. It often proves 'cheaper' to read all the data.

It seems that once Teradata has to read 1% of the rows in a table, it usually does a table scan.

I'd like to hear what others think about this 1% rule vis-a-vis table scans.

Good Luck.


Rgrds,

Bill Gregg



     
  <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