Optimizing Queries

The topics covered here relate directly to tasks you can accomplish in the Data View Builder while building and testing BEA Liquid Data for WebLogic^TM queries. See Tuning Performance in Deploying Liquid Data for a broader discussion of factors related to tuning and performance of Liquid Data including query design, data sources, and platform considerations.

The following sections are included here:

• Factors in Query Performance
• Using the Features on the Optimize Tab
• Source Order Optimization
• Optimization Hints for Joins

• Choosing the Best Hint
• Using Parameter Passing Hints (ppleft or ppright)
• Using a Merge Hint