Sybase IQ supports new syntax that lets you specify per-condition hints, such as selectivity, usefulness, index preference, and execution phase, within the text of a query.
Under normal circumstances, there are no advantages to delaying evaluation, which could slow the query. You can, however, move certain behaviors to later in the query.
For syntax, parameters, and examples, see “User-supplied condition hint strings,” in Chapter 3, “SQL Language Elements,” in the Sybase IQ Reference Manual.
