This credential earner has completed instructor-led learning for understanding how to prevent SQL performance problems and how to improve the performance of existing SQL. Topics include: understanding and designing better indexes; determining how to work with the optimizer (avoid pitfalls, provide guidance); optimizing multi-table access; working with subqueries; avoiding locking problems; and using accounting traces and other tools to locate performance problems in existing SQL.

• Type Learning
• Level Advanced
• Time Days
• Cost Paid