Execution Plans In Depth By Hugo Kornelis

Sale!

Execution Plans In Depth By Hugo Kornelis

$349.00 $159.00

Execution Plans In Depth By Hugo Kornelis

Abstract: For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper.

In this full-day workshop, you will learn everything you need to be take your understanding of execution plans to the next level. For most of the operators you’ll find in execution plans, we will look at the inner workings, and at properties that affect their behavior. We will also look at how the operators within a plan interact with each other. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.

Aside from explaining most operators, we will also look at how these operators interact, which will help you understand which areas in complex execution plans can cause performance issues.

If you have seen some execution plans but feel you need to bring your understanding to the next level, then this workshop is for you!

Modules:

    1. Common mistakes
    2. Reading data
    3. Combining data
    4. Performance enhancements
    5. Manipulating data
    6. Ordering and grouping data
    7. Parallelism
    8. Changing data
    9. Batch mode

PS: This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Date & Time:
View in your own time zone
Go to Training Class Page

Discount Code:
Get your 50% Discount Code – Click Here

Description

Execution Plans In Depth By Hugo Kornelis

Abstract: For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper.

In this full-day workshop, you will learn everything you need to be take your understanding of execution plans to the next level. For most of the operators you’ll find in execution plans, we will look at the inner workings, and at properties that affect their behavior. We will also look at how the operators within a plan interact with each other. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.

Aside from explaining most operators, we will also look at how these operators interact, which will help you understand which areas in complex execution plans can cause performance issues.

If you have seen some execution plans but feel you need to bring your understanding to the next level, then this workshop is for you!
Modules:

    1. Common mistakes
    2. Reading data
    3. Combining data
    4. Performance enhancements
    5. Manipulating data
    6. Ordering and grouping data
    7. Parallelism
    8. Changing data
    9. Batch mode

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.