Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2011 @ 08:44:57 GMT

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

Subj:   Re: Tables which don't have stats
From:   Gupta, Vipin

Hi YB,

I think this query will not return table names (or rather correct results) because every table (having PI) will have an entry in dbc.Indexes regardless of stats collection.

     indexstatistics = null          when stats are not collected
     indexstatistics = not null      when stats are collected

View DBC. IndexStats will return indexes defined on the table with stats details, it does not care about 'NULL' in the indexstatistics field.


Vipin Gupta

  <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