Comprehensive SQL Performance Tuning LECCO SQL Expert Data

Comprehensive SQL Performance. Tuning LECCO SQL Expert Data Hat Oy Pekka Hokka Cemo Timucin

Data Hat Oy Vaatimusten Hallinta Konfiguraation Hallinta ASQ SQL Optimointi

Lecco Technology Fact Sheet - The Company Lecco Technology is focussing exclusively on automatic SQL optimization · Founded in 1995 · Headquarters in Hong Kong · Offices in USA, Canada, UK · 100% Focus on SQL Development · Automated SQL Optimizing · SQL Expert Finds and Fixes ALL SQL Problems

Automaattinen optimointi ---SQL ---- ---SQL ---- ---SQL ---- ---SQL ---- ---SQL ---- ---SQL ---- … … ---SQL ---- …

Automaattinen optimointi ---SQL ---- 28 s 12 s ---SQL ---- 8 s ---SQL ---- 18 s 54 s 38 s ---SQL ---- ---SQL ---- 2 min ---SQL ---- 3 min 59 s ---SQL ---- ---SQL ---- 56 s 2 s ---SQL ---- ---SQL ---- … … ---SQL ---- … Lecco SQL Expert for Developers and DBAs • SQL Optimizer • SQL Inspector • SQL Scanner • Stored Outlines Manager • PL/SQL Programmer • Code Finder • Object Extractor • SQL Formatter • Database Explorer

New Functionality DB Expert v 3 • Index Expert • Virtual Index Simulator • Index Impact Analyzer • Plan Version Tracker • Index Monitor • Database Administration Functions • Enhancements to the Syntactical SQL Optimizer

New Functionality Index Expert • Provides index advice for a SQL statement • Generates every possible index set combination • Automates the currently manual and time intensive process of writing, evaluating and testing indexes • Extends the Feedback Searching Engine to generate every possible index set • Options: B-Tree Index, bitmap index, composite index, key-compressed index, eliminate duplicated cost indexes, Index Expert Intelligence level, Parallel N

New Functionality Virtual Index Simulator • Simulates the creation of indexes and displays execution plans based on virtual indexes • Displays the execution plan for every index set combination provided by Index Expert that Oracle would generate if the indexes were physically created • Predicts the performance implications of the index set on the SQL-statement without impacting the database • Used in conjunction with Index Expert ensures that when the indexes are physically created they are the most efficient

New Functionality Index Impact Analyzer • Evaluates the effect of the creation of the indexes in the database system without affecting the database performance • Analyzes which SQL statements are impacted by the index sets • Identifies the index set which yields the highest performance gain with the least impact in the database system

New Functionality Plan Version Tracker • Ensures reliable database performance by tracking execution plan changes • Identifies the plan changes from different database environments for any given scenario • Allows the user to preempt any SQL performance changes • Analyzes which execution plans are impacted by database environment changes • Enables user to conduct a historical analysis stored execution plan snapshots Good reasons to use it: - Deployment between development and production - Database migration, database version upgrade, data re-org, index changes, database re-design, …

New Functionality Index Monitor • Monitors index usage in Oracle 9 i • Helps DBAs to identify and manage the indexes that are critical • Allows DBAs to identify unused indexes that can be deleted to reduce maintenance, free space and improve performance

New Functionality Database Administration Functions • Enhanced Database Explorer allows users to create, alter and drop database objects through a GUI without typing SQL commands • Database Explorer also allows users to compute statistics for tables and indexes • Facilitates everyday DBA tasks Integration of daily database administration functionality with performance management

New Functionality Enhancements to the Syntactical SQL Optimizer • Graphs run time statistics for source and alternative SQL statements • Incorporates 20 new Oracle hints in the Preferences • Enhanced preferences for PARALLEL hint • Enhance Intelligence of SQL transformation

New Functionality Lecco DB Expert v 3 • SQL Optimizer • SQL Inspector • SQL Scanner • Stored Outlines Manager • PL/SQL Programmer • Code Finder • Object Extractor • SQL Formatter • Database Explorer • Index Expert • Virtual Index Simulator • Index Impact Analyzer • Plan Version Tracker • Index Monitor • Database Administration Functions • Enhancements to the Syntactical SQL Optimizer

More Information • www. leccotech. com a free trial and collateral • www. datahat. com 09 - 8559 2500 sales@datahat. com

Thank you for your time. . . Data Hat Oy Pekka Hokka