Performance Optimization

FirmaLabs’ consultants, specialize in building highly scalable, performant Teradata solutions across a wide range of industries. Below are a few examples of our Performance Optimization Services and methods:

• Performance Monitoring and SQL Query Optimization
• Explain plans
• Statistics collection
• Indexing
• Query Banding
• Data distribution across AMPS
• Primary (PI), Paritioned Primary (PPI) & Secondary indexes (SI) selection
• Locking strategies
• Pushdown optimization in ETL process
• Hints
• Fallback
• Data Type Optimization
• SQL Trace
• TSET Utility
• PDCR – Performance data collection and reporting (Suspect * SQL, Skew, High CPU and IO consumer)
• Automated scripts for montoring and alerts for issues like Perm space, Blocking Issues, High CPU Consuming Sesssion, High Spool Consuming Sessions etc
• Suggest Index methods to minimize skew on highly skewed tables and improve space utilization
• Multi value Compression (MVC) to help in saving disk Space and reduced the IO.

[… See More Teradata Services](/services/