Oracle SQL Tuning Tips Webinar

Dave Anderson is delivering a webinar October 25th and November 8 from 1:00 – 2:30 PM (Eastern) on Oracle SQL tuning tips. Topics include:

• Overview of SQL Tuning Tools including 10053 Event Trace
• Things You Should Know About CBO
• Top coding mistakes and "gotchas"
• Avoiding Non-Indexable Conditions
• NULLs and B-Tree Indexes
• Implications of Wildcard Searches
• Using Oracle Text Indexes
• Issues with Implicit Type Conversion
• EXISTS vs. DISTINCT (Performance)
• UNION ALL vs. UNION
• Use Caution with NOT IN
• SQL CASE Expression for Performance
• Subquery Factoring for Performance
• Oracle Analytic Functions
• Adjusting Arraysize for Performance
• The Oracle MERGE Statement
• MERGE vs. Manual Merge Comparison

To register send e-mail to: gary@skillbuilders.com