Sybase IQ: Understanding Optimization Improving Performance

Goals

• Design and implement indexes that are efficient & effective
• Read Query Plans and illustrate how the nodes of query plans affect query processing, including joins & group by nodes
• Explain how the query engine processes queries
• Demonstrate how to setup, execute and interpret query timing diagrams

Audience

• Sybase IQ Consultants and Developers, Database Administrators, Data Warehouse Architects

Prerequisites

• * EDB772: Sybase IQ for Developers OR EDB782: Administering Sybase IQ for the Data Warehouse OR equivalent work experience * Exposure to Sybase IQ Architecture * Background in SQL, Relational databases, and data warehousing

Content

• Designing Effective Indexes & Queries
• Query Engine Architecture
• Joins & Group By Nodes Processing
• Understanding Sybase IQ Query Plans
• Interpreting Query Timing Diagrams

Notes

• Learn through lectures and intensive hands-on instruction how to get the most out of your Sybase IQ.
• Explore how to optimize queries and indexes to achieve optimal query processing by thoroughly understanding the principles of the Sybase IQ runtime engines.
• This will allow you to better design indexes & queries that run optimally in your own environment.
• Use the Index Advisor and monitoring tools to troubleshoot and repair inefficient and ineffective queries.
• You will then learn how to read and interpret Query Timing Diagrams and Query Plans to troubleshoot your queries or indexes.

Popular tags

No tags submitted for this course yet