Advanced Features of ADF - Oracle ADF 11gR2 Development Beginner's Guide - page 257

AccessMode : This defines how the row is accessed in a view object. The modes are
as follows:
SCROLLABLE : This mode is used to cache rows in a collection.
FORWARD_ONLY : This mode is used for sequential access to rows in
a collection.
RANGE_PAGING : The paging is done based on the defined value
of RangeSize . If the rows that are requested are not in the range,
the rows are fetched from the database using the ROWNUM query.
RANGE_PAGING_AUTO_POST : The rowset will post any changes in the
transaction for rows out of the current range.
Query Opimizer : These are hints added to a query to help retrieve the record
eiciently. This will inluence the execuion plan of the query. The modes are
as follows:
ALL_ROWS : This mode fetches all rows as quickly as possible
FIRST_ROWS : This mode fetches the first row as quickly as possible
SQL Mode : Use the view object SQL mode to control the area from which
the rows have to be retrieved. You can combine the following query modes
to retrieve records efficiently:
QUERY_MODE_SCAN_DATABASE_TABLES : This mode is used to scan rows
from the database. This is the default mode.
QUERY_MODE_SCAN_VIEW_ROWS : This mode is used to scan rows from the
view cache. This mode uses the existing rows and will not go back to the
database.
QUERY_MODE_SCAN_ENTITY_ROWS : This mode is used to scan rows from
the entity cache. This mode uses the entity object rows that are valid for
entity-based view objects.
Associaion Consistent : When using two view objects that have the same enity
type, one view object is noiied about the changes made to an enity through
the other view object via the flag to view link consistency. The flag to view link
consistency is jbo.viewlink.consistent in the AM coniguraions, which can
be performed programmaically using setAssociationConsistent(true) .