Archives of the TeradataForum
Message Posted: Wed, 31 Jan 2007 @ 10:08:19 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|