Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 May 2012 @ 17:01:52 GMT

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

Subj:   Re: Dropping stats on indexes
From:   Dave Wellman


What happens to the stats depends on whether the index is a single or multi-column index.

Single column stats (whether an indexed column or not) are stored with the column definition (in DBC.TVFields). These will remain if you drop a single column index.

Multi-column stats are stored in DBC.Indexes. If the stats are on an index definition then when you drop the index the stats get dropped as well.



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

  <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: 28 Jun 2020