Transcript Training Guide

Comprehensive SQL PerformanceTuning
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
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
…
…
---SQL
----
…
Automaattinen optimointi
---SQL
----
28s
---SQL
----
---SQL
----
8s
---SQL
----
12s
18s
54s
38s
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
2min
---SQL
----
---SQL
----
3min
59s
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
56s
2s
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---SQL
----
---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 v3
• 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 9i
• 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 v3
• 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
[email protected]
Thank you for your time...
Data Hat Oy
Pekka Hokka