Informix SQL Optimization
Event:
Title:
Informix SQL optimization
Course code:
S258
Date:
On request
Duration:
3 Days
Cost per person:
1.650,00€ plus VAT
Organizer:
LIS.TEC GmbH
Location:
Ludwigsburg
Services:
Small study groups
Food & drinks
Seminar documents and training in german
If you register for several participants, we offer interesting graduated discounts.
You can register by sending an e-mail to schulung@listec.de
Contact: Herr Joachim Klassen
Telephone: +49 (0) 7141 93 93-0
Description:
The topic of “SQL Optimization” not only covers the topic of “finding and optimizing problematic SQL statements”, but also demonstrates the benefits of parallelized queries on multi-fragmented compressed tables and provides guidance on how to get through administrative intervention Optimizing OLAP and OLTP queries as best as possible.
The topics at a glance:
- optimization cycle
- target definition
- Wait statistics
- Activation
- Total System Review
- Evaluation of individual sessions
- SQL trace
- Activation
- Time evaluation of the history
- Set Explain
- Passive activation
- Benefit of the indices
- To find specific key values
- To avoid sorting in ORDER BY / GROUP BY
- To find intersections “Forrest of trees”
- Key-only reads
- Cluster indices
- Expense of an index
- For creating and finding large numbers of hits
- Nested loop join
- Dynamic hash join
- Combination of dynamic hash join and index access
- statistics
- Basic data of the optimizer
- Automatic update of statistics
- Is the optimization path correct?
- Easy check if the optimization path is correct
- Use of directives for the optimizer
- Combination of optimizer directives with complex SQL statements
- Problem with using views
- Parallel sorting and grouping
- Use of fragmented tables
- for parallel I/O processing
- Reduction of the I/O effort by fragment elimination
- Use of fragmented indexes
- Fragmentation of tables
- simple compression
- Compression with cluster indices