Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Jul 2008 @ 09:14:56 GMT


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


Subj:   Re: How to Analyze tables in Teradata?
 
From:   Kumar, Prem

Let me add some more points.

There is no "Analyze table" command in teradata. But you can make use of the statistics wizard.

1) You can use Teradata Statistics wizard & Gather statistics based on recommendations.The Statistics Wizard also recommends when statistics should be recollected on those columns. Statistics Wizard analyzes a workload and makes recommendations, based on the defined workload.

2) You can define workload by using

a) dbql

b)statement text

c)QCD statements

d)Import workload


Regards,

Prem



     
  <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