Washington Area Informix Users Group

Tuning DSS Queries

3/25/00


Click here to start


Table of Contents

Tuning DSS Queries

Tuning DSS Queries

Example

Info

Tools

Tools (2)

Tools (3)

Tools (4)

Tuning Procedure

How fast can we scan a table?

PDQPRIORITY

Light Scans

UPDATE STATISTICS

Indexes

Hash Join

TEMP Disk

BALANCE

The OUTER JOIN

Inner (HASH) join between A and B

Add Table A + 1

Add Table B + 2

Select key + MAX(IND)

Inner (HASH) join between Temp 1 and 2

Update Thoughts

Reporting Thoughts

After Tuning

ONCONFIG changes (DSS)

Author: Jack Parker

Email: jparker@engage.com