Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 17 Nov 2004 @ 20:55:03 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: COLLECT STATISTICS from macro
From:   Claybourne Barrineau

Basically, as the others have indicated, you cannot do this in a macro.

As a cheesy work-around (beware...this solution has its own set of associated risks) you can insert into a physical table (versus a global temp) with a user_id column and pre-seeded statistics. For instance, build your physical table, load it with a demographically representative batch of data, collect stats, delete data. For this point forward, your macro can insert into this physical table.

In this case, fake stats may be better than no stats (if you pre-seeded stats are truly representative of the data) and are 100% better than stats collected on an empty table.

Hope this helps,


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019