2.16 APPROX_FOR_PERCENTILE
APPROX_FOR_PERCENTILE
converts exact percentile functions to their approximate percentile function counterparts.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Basic |
No |
Oracle RAC |
Different instances can use different values. |
Approximate percentile function queries are faster than their exact percentile function query counterparts, so they can be useful in situations where a tolerable amount of error is acceptable in order to obtain faster query results.
The values that can be set are:
-
NONE
:No queries are converted. This is the default value.
-
PERCENTILE_CONT
:Converts
PERCENTILE_CONT
queries toAPPROX_PERCENTILE
queries. -
PERCENTILE_CONT DETERMINISTIC
:Converts
PERCENTILE_CONT
queries toAPPROX_PERCENTILE DETERMINSTIC
queries. -
PERCENTILE_DISC
:Converts
PERCENTILE_DISC
queries toAPPROX_PERCENTILE
queries. -
PERCENTILE DISC DETERMINISTIC
:Converts
PERCENTILE_DISC
queries toAPPROX_PERCENTILE DETERMINISTIC
queries. -
ALL
:Converts both
PERCENTILE_CONT
queries andPERCENTILE_DISC
queries toAPPROX_PERCENTILE
queries. -
ALL DETERMINISTIC
:Converts both
PERCENTILE_CONT
andPERCENTILE_DISC
queries toAPPROX_PERCENTILE DETERMINISTIC
queries.
See Also:
-
Oracle Database SQL Language Reference for information about
APPROX_MEDIAN
aggregate functions -
Oracle Database SQL Language Reference for information about
APPROX_PERCENTILE
aggregate functions