Query optimizer

The following reference documents provide details on SEP’s powerful query optimization tools. The information helps you to understand how Dell Data Analytics Engine, powered by Starburst Enterprise platform (SEP) achieves higher query performance out of the box, and how to further improve SQL query performance.

The following pages describe how SEP works to efficiently process queries:

• Table statistics
• Managed statistics
• Pushdown
• Cost-based optimizations

Learn how to read an EXPLAIN plan to help you to understand costs and improve the performance of your queries:

• Cost in EXPLAIN

Starburst offers configuration properties to help you refine query performance even further:

• Starburst optimizer properties

Before diving into the docs, watch our query optimization training videos. They includes in-depth information on the tools and techniques you need to make your queries run fast and efficiently, covering topics such as: the query lifecycle the EXPLAIN statement general optimizations cost-based optimizations

View the training