Performance tuning
This information describes the performance guidelines for operations such as loading data and tuning.
Examples of performance optimization include:
- Allocating appropriate CPU and memory resources to Big SQL
- Tuning HBase performance
- Setting an appropriate number of logical workers in order to improve parallelism
- Using appropriate data types
- Setting informational constraints to provide useful information to the Big SQL query optimizer
- Setting performance registry variables to improve compiler and runtime performance
- Adjusting temp space database directories
For an overview of methods to optimize performance in Big SQL, see Big SQL v5 Best Practices and Guidelines - Performance.