Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 11 Nov 2013 @ 11:19:19 GMT


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


Subj:   Re: Statistics on multi column UPI
 
From:   Sughesh.Sumansingh

Sravan Kumar Bodla wrote:

  I have a question here.  


  If UPI is defined on 5 columns, what if only 1 or 2 columns are used in the where condition, will the query takes advantage of UPI in this case?  


  Or all the 5 columns needs to be used in the where condition everytime?  


Hi Sravan,

If your index is partially qualified, system will go for FTS.


Thanks,

Sughesh.



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

Attachments

Library

Quick Reference

 

Archives

Sample Index

2016  2007
2015  2006
2014  2005
2013  2004
2012  2003
2011  2002
2010  2001
2009  2000
2008  1999

 

2013 Indexes

Jan  Jul
Feb  Aug
Mar  Sep
Apr  Oct
May  Nov
Jun  Dec


 
 
 

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