Analyzing your database environment can provide significant performance riches, provided you have the right tools for the job. Visual Explain fits the bill, but learning to understand Visual Explain diagrams can be overwhelming and difficult. This session provides an introductory look into how to read and analyze your Visual Explain diagrams to find SQL performance gold.
Date & Time
Wednesday September 18th, 2024 11:00am EDT
End Date & Time
Wednesday September 18th, 2024 12:00pm EDT
Venue
Calusa H
Speakers
Ryan Moeller
Session Format
Standard 60 Minute Session
Learning Objectives
- Identify the various methods of collecting data to produce a Visual Explain diagram
- Understand how to understand the flow of data through a Visual Explain diagram
- Learn to perform basic query access plan analysis, including learning about various Visual Explain node types
Audience
Programmers wishing to improve their SQL skillset, early tenure database administrators
Session Level
Intermediate
Conference NAViGATE Florida
Session Comments