ODAC
The SmartFetch mode is used for fast navigation through a huge amount of records and to minimize memory consumption.
TOraDataSet
property SmartFetch: TSmartFetchOptions;