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)
Email: jparker@engage.com