Tuning pluggable SQL
You can tune the SQL statements generated using the administration services to suit customized requirements or improve performance.
About this task
InfoSphere® MDM is shipped with out-of-the-box pluggable SQL statements for certain inquiry levels. If you wish to tune these out-of-the-box SQL statements, you must create a user-defined version of the inquiry level, along with all associated objects, and then tune the SQL generated from this new version of the inquiry level.
Procedure
- Modify the SQL statement as required. SQL statements for inquiry levels are concatenated using the delimiter
<STMT>
. You must maintain the same pattern while tuning the SQL. - Use the updateInquiryLevelQuery transaction to persist the updated SQL statement.
Results
The modified inquiry level can now be used in inquiry transactions that support configurable inquiry levels.