Skip Headers

# Configuring Named Query Optimization

Previous

Next

You can optimize a named query by configuring batch (`ReadAllQuery` only) or joining (`ReadAllQuery` and `ReadObjectyQuery`) attributes.

For more information on using batch reading, see Query Optimization, "Reading Case 2: Batch Reading Objects", and "Using Batch Reading".

For more information on joining, see "Join Reading and Object-Level Read Queries" and "Using Join Reading".

Use this tab to specify batch reading and joining attributes.

Select one of the following actions for Batch Read Attributes (`ReadAllQuery` only):

- To add a new batch read attribute, click Add. The Add Batch Read Attribute dialog box appears. Select the mapped attribute and click OK.

- To change the order of the batch read attributes, select an existing attribute and click Up or Down.

- To modify an existing batch read attribute's options, select an existing attribute and click Edit.

- To remove a batch read attribute, select an existing attribute and click Remove.

Select one of the following actions for Joined Attributes (`ReadAllQuery` and `ReadObjectQuery`):

- To add a new joined attribute, click Add. The Add Joined Attribute dialog box appears.

  Select the mapped attribute. Optionally, enable or disable Allows Null or, for a `Collection` attribute, Allows None. Click OK.

- To change the order of the joined attributes, select an existing attribute and click Up or Down.

- To modify an existing joined attribute's options, select an existing attribute and click Edit.

- To remove a joined attribute, select an existing attribute and click Remove.