SQL Performance

Code: SQLPERF

Description

-

Audience

-

Prerequisites

It is assumed that participants have at least a basic knowledge of SQL. They should also be familiar with the concept of logical files (DDS described logical file or SQL index).

Objectives

-

Topics

Database Architecture

  • From CQE to SQE

Query Process

  • Optimization Process
    • Statistics Manager
    • Access Plan
  • Opening Process
    • Open Data Path (ODP)
    • Full Open / Hard Close
  • AQP (Adaptive Query Processing)

Access Methods

  • Permanent Objects
    • Table Scan / Table Probe
    • Index Scan / Index Probe
  • Using temporary Objects

Indexing Strategy

  • Access Paths
    • Key Constraints / Binary Radix Indices
    • Encoded Vector Indices (EVI)
  • Proactive / Reactive Indexing Strategy

Analysis Feedback Tools

  • Index Advisor / Condenser / Evaluator
  • Visual Explain
  • SQE Plan Cache (Snapshots)
  • Database Monitors

Coding Tips

QAQQINI Options

Price (ex. VAT)

€ 2.460,00 per person

Duration

3 days

Schedule

Please send us a message with the form below

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us