Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 12:14:24 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Defining SI on columns that are part of PI
From:   DWellman


I don't believe there's a 'problem' with definining an SI on a column which is also part of the PI. In some (very specific) cases involving PPI's this can actually be an advantage.

Whether the SI helps with joins or not is (as always) to do with data volumes, selectivity, the sql etc. You can't easily predict it ahead of time. Can you try it ? Add the SI, explain some queries and see whether the SI gets used.



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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