FIRST_ROWS and ALL_ROWS Options (IDS)

The FIRST_ROWS and ALL_ROWS options relate to the optimization goal of the query:

• FIRST_ROWS

  This option directs the optimizer to choose the query plan that returns the first result record as soon as possible.

• ALL_ROWS

  This option directs the optimizer to choose the query plan that returns all the records as quickly as possible.

You can also specify the optimization goal of a specific query with the optimization-goal directive. For more information, see Optimizer Directives.