'Plan table' diaporamas de présentation

IBM Software Group

IBM Software Group. Performance Prediction for DB2 Upgrades to DB2 z/OS V9 . New England DB2 User's group September 17, 2009 Hussaina Husain Certified Consulting I/T Specialist IBM East Region zSeries DB2 Tools Technical Sales. Some of the Challenges.

1.02k views • 81 slides

SQL Tuning via Toad

683 views • 50 slides

Department of Computer and Information Science, School of Science, IUPUI

Department of Computer and Information Science, School of Science, IUPUI. SQL Tuning Introduction. Dale Roberts, Lecturer Computer Science, IUPUI E-mail: droberts@cs.iupui.edu. Oracle Data Dictionary. Data Dictionary:

309 views • 16 slides

Agenda

Agenda. Overview of the optimizer How SQL is executed Identifying statements that need tuning Explain Plan Modifying the plan. Optimizer. Attempts to find best path Mode is set in init.ora file (can also be set for a session) Rule Based Init.ora optimizer_mode = rule

250 views • 13 slides

Agenda

Agenda. Overview of the optimizer How SQL is executed Identifying statements that need tuning Explain Plan Modifying the plan. Optimizer. Attempts to find best path Mode is set in init.ora file (can also be set for a session) Rule Based Init.ora optimizer_mode = rule

133 views • 13 slides