Limiting the number of rows returned by the execution of an SQL statement

You can select to limit the number of rows returned by the execution of an SQL statement. If you select to do this, it should decrease the amount of time it takes to execute the statement.

To specify the maximum number of rows that can be returned when an SQL statement is executed:

1. Click Windows > Preferences.

2. In the Preferences window, expand the Data node, and then click SQL Query.

3. Select the Limit rows returned from SQL statement execution check box.

4. In the Maximum rows returned from SQL Statement execution field, specify the maximum number of rows to return when an SQL query is executed.

5. Click OK.

Now, whenever you execute an SQL statement, the maximum number of rows returned is no greater than the amount you specified in the Maximum rows returned from SQL Statement execution field.

 

Parent topic

Executing an SQL statement