DEPOT_FETCH
Eon Mode only
Specifies whether a query fetches data to the depot from communal storage when the depot lacks data for this query. This hint overrides configuration parameter DepotOperationsForQuery.
Syntax
SELECT /*+ DEPOT_FETCH (option)*/ …
Arguments
option |
Specifies behavior when the depot does not contain queried file data, one of the following:
|
Examples
SELECT /*+DEPOT_FETCH(All)*/ count(*) FROM bar; SELECT /*+DEPOT_FETCH(FETCHES)*/ count(*) FROM bar; SELECT /*+DEPOT_FETCH(NONE)*/ count(*) FROM bar;