IQ Tips Tricks and Common Issues

This masterclass will cover common problems, issues and bugs that impact Developers and DBA's when using IQ. The root of most performanceproblems in IQ is the usage or absence of parallel processing and the interaction between the IQ and ASA stores. This session will explain how to optimise code and options (both documented and hidden) to take advantage of IQ's parallel processing. A large focus will also be directed at the interaction between IQ and Catalog/ASA stores, how to understand which store your code is being executed in and how to avoid common traps that can occur in the interaction between the stores. The content shall also introduce two tips on how to pass a table/indeterminate parameters into a procedure using XML and how triggers can be used in IQ.

• Parallel Processing - 15 mins
• Server Options that effect parallel processing
• Database Options that effect parallel processing
• How parallel processing can cause errors
• Table Locking issues with Parallel Processing
• How to improve parallel processing
• Load Table
• Views- Issues and workarounds - 10 Mins
• Differences in SARGS and JOINs
• Datatype Mismatches
• View Materialisation
• Insert-Select vs Insert-Location Vs Insert-Values - 5 Mins
• Speed differences and workarounds
• ASA - The root of the problem? 
• Identity Issue via ASA
• Strange Results
• User Defined Functions
• Joins with ASA
• Locking
• ASA Tables
• Table Variable Workaround - XML - 5 mins
• How to use XML to pass tables to procedures
• Triggers m- 5 Mins
• Limitations and usage