Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Jan 2012 @ 13:06:42 GMT

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

Subj:   Re: Generate collect statistics statement

1. I generated collect stats statements on index columns of DBC tables. But running collect stats on those DBC tables failed. I wonder if this is normal. In DB2 V8 I can't run SELECT on some of sysibm tables. Is this a similar situation?

2. I was told to run collect stats on columns used in WHERE clause also. I'd like to generate and run collect stats on columns used in WHERE clause of all tables on database level. If you have the statement it's going to be helpful for me to test and run.

Thank you for your support.


James Park
Database Specialist II

  <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: 23 Jun 2019