- Typically TOP 50 queries will consume >25% of all resources.
- Cut high CPU, I/O and Spool consumes
- Eliminate skewness for utilize maximum parallel efficiency
- Find and solve these issues with PRISE
Reduce I/O load by compression
- Significant I/O reduction can be achieved by applying multi value compression w/o CPU tradeoffs.
- Use PRISE Compress Wizard to check
your system and reduce storage space and I/O by around 30%.
Check out how Teradata optimization can reduce your cost!