Using the SPACE Built-In Functions
Windows Examples
Indexed spaces have been primarily designed to support "batch" style functions that process large volumes of information. They have been designed to provide:
Here you will find examples of how to use the SPACE built-in functions:
Windows Examples
Indexed spaces have been primarily designed to support "batch" style functions that process large volumes of information. They have been designed to provide:
- An optimised way of accumulating aggregate multi-level summary information.
- An optimised way of randomly and repeatedly accessing large lists of information without the overhead of a database row access, in other words you can load the required information into an indexed space at the start of your function and then repeatedly (re)access the indexed space more efficiently than you can by accessing the DBMS directly.
Here you will find examples of how to use the SPACE built-in functions: