Indexing

---

For read and take operations, XAP iterates non-null values that match template or SqlQuery criteria, returning matches from the Space. This process can be time consuming, especially when there are many potential matches. To improve performance, it is possible to index one or more Space class properties. The Space maintains additional data for indexed properties, which shortens the time required to determine a match, thus improving performance.

---

• Basic concept
  Basic index types

• Indexing Nested properties
  An index can be defined on a nested property to improve performance of nested queries.

• Indexing collections
  An index can be defined on a Collection property.

• Compound index
  Compound indexes can be defined using multiple class properties.

• Unique index
  Unique constraints can be defined for a property or properties of a space class.

  ---