The Maximum Rows to Fetch property specifies the maximum number of rows of data that the query should retrieve. Reports Builder will only retrieve the number of rows for the query that you specify in this property. When you are designing a report, you often must run it many times to see how it looks. If your report retrieves a lot of data, this can be very time consuming. This property can improve performance by reducing the amount of data retrieved and formatted.
Applies to |
Queries |
Values |
A whole number from 1 through 32K means that only that number of rows will be retrieved . If left blank, all rows are retrieved. To restrict the rows retrieved by some, but not all, of a query's groups, use the Filter Type property in the Group properties. |
Default |
Blank |
Required/Optional |
Optional |
PL/SQL procedure |
Difference between group filters and Maximum Rows: The Maximum Rows to Fetch property restricts the actual number of records fetched by the query. A group filter determines which records to include or exclude, after all the records have been fetched by the query. Since Maximum Rows to Fetch actually restricts the amount of data retrieved, it is faster than a group filter in most cases. If you use a Filter of Last or Conditional, Reports Builder must retrieve all of the records in the group before applying the filter. Also, you should be aware that when using Maximum Rows to Fetch for queries. It can effect summaries in other groups which depend on this query. For example, if you set Maximum Rows to Fetch to 8 any summaries based on that query will only use the 8 records retrieved.
Copyright © 1984, 2005, Oracle. All rights reserved.