Difference between revisions of "SET OPTIMIZE"

Latest revision as of 16:26, 23 November 2009

Deprecated in Recital 10

Purpose

Enable or disable the query optimization

Syntax

SET OPTIMIZE ON | OFF | (<expL>)

See Also

DESIGN, FOR(), INDEX, INFO, REINDEX, SET CATALOG, SET DESIGN, SET INDEX, SET ORDER, SET VIEW, USE

Description

The SET OPTIMIZE command enables or disables the query optimizer in the Recital Information Center. When SET OPTIMIZE is ON, an index order which optimizes the current FOR condition is chosen. Based on the requirements specified in the FOR condition, the best-suited index among those associated with the currently active table is selected. If no index is found which can optimize the query, a sequential search is performed. When SET OPTIMIZE is OFF, a sequential search will always be performed in connection with a FOR condition. The SET INDEX and USE commands can both open a list of single indexes to be associated with the active table. Up to a maximum of 20 single indexes may be opened per table. Production indexes are opened automatically when a table is opened and can have a maximum of 128 tag orders defined.

The query optimizer operates in the Recital Information Center. The Information Center is a powerful work surface from which any type of data may be accessed, viewed, modified, and organized. With the Information Center you can organize files into catalogs which represent a single application, an application interface, or development project. Depending on your orientation to the data, the Information Center may serve as an application interface, and an organizing and developing tool.

Example

set optimize on
set catalog to sales
info

Products

Recital