Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 26 Jul 2012 @ 08:37:59 GMT


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


Subj:   Re: Help with compression analysis
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, July 26, 2012 00:07 -->

Vijay,

As per teh data you have provided you can do one thing that write a SQL statemnt to get only required rank position using QUALIFY and after that you can merge those all values together using recursive query and that will generate an automated alter table statement to do compression.


Hope it helps.



     
  <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: 28 Jun 2020