These usage notes apply to every function in this document.
- This function requires the UTF8 client character set for UNICODE data.
- This function does not support Pass Through Characters (PTCs).
For information about PTCs, see International Character Set Support, B035-1125.
- This function does not support KanjiSJIS or Graphic data types.
- SELECT TOP gives non-deterministic results. Therefore, identical queries including this instruction may produce different results.
- Input Table Rows Redistribution
- Function Syntax Descriptions
- Size of the Query
- AMP Configuration Impact on Function Execution
- Limitations When Using PARTITION BY
- Functions Ignore Disallowed Syntax Elements
- Input Table Schemas
- Function Names with and without TD Prefix
- Accumulated Columns Impact on Function Performance
- Datatype Change in Accumulated Columns
- View Online Help for Database Analytic Functions
- BC/BCE Timestamps
- Workload Management Configuration for Analytics Database Analytic Functions
- Avoid Deadlocks Using Volatile Tables
- Non-Deterministic Behavior
- Maximum Number of Columns in a Database Table
- Spool Space Exhaustion for Large Partitions at High Concurrency
- Recommendations for Using Analytic Functions