Limiting the rows fetched by a view object
The ADF Business Components framework allows you to declaratively and/or programmatically set an upper limit for the number of rows that can fetched from the database layer by a view object. Declaratively, this can be accomplished through the view object Tuning section in the General page of the view object Overview editor. You can do this by selecting Only up to row number in the Retrieve from the Database section and providing a row count.
This can also be accomplished programmatically by calling a view object's
setMaxFetchSize() method and specifying an upper row limit.
To globally set an upper limit for ...