Optimiser choices in determining the execution plan for complex queries is a dominant factor in the performance delivery for a data foundation environment. The goal of this workshop is to de-mystify the inner workings of cost-based optimisation for complex query workloads. We will discuss the differences between rule-based optimisation and cost-based optimisation with a focus on how a cost-based optimization enumerates and selects among possible execution plans for a complex query. The influences of parallelism and hardware configuration on plan selection will be discussed along with the importance of data demographics. Advanced statistics collection is discussed as the foundational input for decision-making within the cost-based optimiser. Performance characteristics and optimiser selection among different join and indexing opportunities will also be discussed with examples. The inner workings of the query re-write engine will be described along with the performance implications of various re-write strategies.

Early bird pricing is available until 2 weeks prior.

This is an AlphaZetta public course – group discounts are available during the Early bird period (up to 2 weeks prior): 5% for 2–4 people, 10% for 5–6 people, 15% for 7–8 people, and 20% for 9 or more people. Discounts are calculated during checkout.

Course Booking Terms and Conditions

Additional Information

Audience Expert –  architects, BI analysts, and data scientists interested in learning to use advanced analytic techniques to find insights in data and who have at least some scripting experience.
Prerequisites Students should have completed or have equivalent knowledge to the course Data Literacy for Everyone.
Objectives
  • Learn how the best-in-class optimisers work “underneath the hood.”
  • Learn how statistics collected influence a query execution plan.
  • Learn how a query re-write engine and advanced join algorithms impacts performance of a query.
Format Workshop
Duration 3hrs – 1 day, depending on the needs of your organisation
Trainer Stephen Brobst
Delivery Method In-person at AlphaZetta Academy locations or on-premise for corporate groups

Meals and refreshments

Catered morning tea and lunch are provided on both days of the course. Please notify us at least a week ahead if you have any special dietary requirements.

Feedback

Use academy@alphazetta.ai to email us any questions about the course, including requests for more detail, or for specific content you would like to see covered, or queries regarding prerequisites and suitability.
If you would like to attend but for any reason cannot, please also let us know.

Variation

Course material may vary from advertised due to demands and learning pace of attendees. Additional material may be presented, along with or in place of advertised.

Cancellations and refunds

You can get a full refund if you cancel 14 days or more before the course starts. No refunds will be issued for cancellations made less than 14 days before the course starts.

Frequently asked questions (FAQ)

Do I need to bring my own computer?
There’s no need to bring your own laptop or PC. Our courses take place in modern, professional training facilities that have all the computing equipment you’ll need.

Private and Corporate Training

In addition to our public seminars, workshops and courses, AlphaZetta Academy can provide this training for your organisation in a private setting at your location or ours. Please enquire to discuss your needs.

Enquire Now

Scheduled Public Courses

Private and Corporate Training

In addition to our public seminars, workshops and courses, AlphaZetta Academy can provide this training for your organisation in a private setting at your location or ours. Please enquire to discuss your needs.

Enquire Now

Other Data Science Curriculum