Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 May 2011 @ 12:04:40 GMT


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


Subj:   Re: Partitions and Statistics
 
From:   Minakshi Swami

1) u can check this is dbc.indices or dbc.IndexStats where indextype='q'

2) where IndexStatistics(column in dbc views) is null

Yes,you should

PARTITION. This tells the optimizer how many partitions are empty, and how many rows are in each partition. This statistic is used for optimizer costing.

The partitioning column. This provides cardinality estimates to the optimizer when the partitioning column is part of a query's selection criteria.


Thanks & Regards,

Minakshi Swami



     
  <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