ATO (Automated Table Optimizer) is a new revolutionary tool that changes your view of space management within the Teradata Data warehouse. It is the ultimate answer to table optimizations and can quickly bring your DWH up to speed!
After Teradata introduced multi-value compressions, clients all over the world slowly began to accommodate this feature and exploit its benefits. Smaller is better. Not only do you save valuable space, but you also benefit from the improved performance.
The table optimization process includes: identification of the right candidates (bad performing tables) worth investing your time and effort, collection of statistical data, performing all the necessary analyses, making educated decisions all the way to the actual implementation of the changes in production. If you want to get it right, this is a continuous and time-consuming process that requires trained human resources. And that's where ATO comes in handy.
ATO proven to be a sophisticated tool that automatically scans your DWH and successfully carries out all the steps on your way to get the most out of your current configuration. It saves you time, it saves you space, it saves your money! Still not convinced? Then you might want to know, you can not only get ATO as a tool, but also as a service!
"It's briliant, easy to use, saves a lot of time and space. The generation of the DDL is a real timesaver."
Fachtna O'Donovan
ATO can save up to 80% of the physical table size, averaging at nearly 40% per table?