Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Dec 1999 @ 11:00:38 GMT


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


Subj:   Re: Search with a wildcard
 
From:   Yves Mackels

When you use the "LIKE" clause in your select in order to match a certain string with a wildcard Teradata is doing automatically a Full table scan. Teradata needs to scan each string in order to find those that match the "LIKE" clause.


Mackels Yves



     
  <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