Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 31 Jan 2007 @ 10:08:19 GMT


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


Subj:   Re: How Do You Measure/Validate Compression Savings?
 
From:   Barner Eric

A tool won't save you any more than an appropriate analysis and implementation of multivalue compression.

The tool just provides a quicker way to do things, and the implementation can be done by someone who doesn't quite understand what they are doing, yet yielding good results.

A good DBA, with a little effort, can do as well as any tool.

For thousands of dollars in initial investment , 10k to 20k I imagine, for 1 license for a tool plus new licenses in the future is expensive.

PL\SQL & Macros does require that much maintenance once it is implemented. It took me 2 weeks to customize the code that was posted here, test it, and implement it.

In my experience implementing MVC by writing Procs & Macros, is more cost effective than buying a tool (so far).

I have helped evaluate a tool, and it was great. If you need other functionality delivered by the tool then get the tool.

If you only seek to achieve this one task, as I did, it was cheaper to implement it on my own.

A tool will still yield a positive cost savings, its just that a little elbow grease will probably save a little more in the long run.


Just my 2 cents.

-Eric



     
  <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