Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 16:28:36 GMT

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

Subj:   Re: Use of Indexes in Teradata
From:   Srikanth Goli


The PPI option ranging on SaleDate seems to be much better option since most delete clauses specify a SaleDate and StoreID (with equality constraint), and in fact most of the deletes fall on a day or two. This seems even better then NUSI option with the additional space requirements of NUSI and the insert penalties. We just tested with PPI and explain plans confirm the hypothesis. Your advice is highly appreciated.


  <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