Query optimization practices
- Optimize table schema design
- Optimize index design and usage
- Optimize queries by using partition pruning
- Use synchronous materialized views for transparent rewriting
- Use asynchronous materialized views for transparent rewriting
- Use Colocate Group to optimize joins
- Use hints to adjust join shuffle methods
- CBO rule control
- Use Leading Hint to control join order