Mathematical functions (Azure Cosmos DB)
APPLIES TO:
SQL API
The mathematical functions each perform a calculation, based on input values that are provided as arguments, and return a numeric value.
You can run queries like the following example:
SELECT VALUE ABS(-4)
The result is:
[4]
Functions
The following supported built-in mathematical functions perform a calculation, usually based on input arguments, and return a numeric expression. The index usage column assumes, where applicable, that you're comparing the mathematical system function to another value with an equality filter.
| System function | Index usage | Index usage in queries with scalar aggregate functions | Remarks |
|---|---|---|---|
| ABS | Index seek | Index seek | |
| ACOS | Full scan | Full scan | |
| ASIN | Full scan | Full scan | |
| ATAN | Full scan | Full scan | |
| ATN2 | Full scan | Full scan | |
| CEILING | Index seek | Index seek | |
| COS | Full scan | Full scan | |
| COT | Full scan | Full scan | |
| DEGREES | Index seek | Index seek | |
| EXP | Full scan | Full scan | |
| FLOOR | Index seek | Index seek | |
| LOG | Full scan | Full scan | |
| LOG10 | Full scan | Full scan | |
| PI | N/A | N/A | PI () returns a constant value. Because the result is deterministic, comparisons with PI() can use the index. |
| POWER | Full scan | Full scan | |
| RADIANS | Index seek | Index seek | |
| RAND | N/A | N/A | Rand() returns a random number. Because the result is non-deterministic, comparisons that involve Rand() cannot use the index. |
| ROUND | Index seek | Index seek | |
| SIGN | Index seek | Index seek | |
| SIN | Full scan | Full scan | |
| SQRT | Full scan | Full scan | |
| SQUARE | Full scan | Full scan | |
| TAN | Full scan | Full scan | |
| TRUNC | Index seek | Index seek |