What are the two kinds of fields in Avaloq?

The two kinds of fields in Avaloq are classified as simple fields and indexed fields. Simple fields refer to basic data storage types that can hold a single value, such as integers or strings. Indexed fields, on the other hand, are designed to improve data retrieval speed by creating an index on certain attributes, allowing for faster query execution when searching through large datasets.

Simple fields are typically used for straightforward data representations, while indexed fields leverage the efficiency of indexing for operations that involve searching or filtering. Understanding this distinction is essential for effective database management and retrieval within the Avaloq framework.