Necessary indexes

For some simple queries, the necessary indexes can be easily identified and readily created with the administration console.

For example, without an index on Property1, the following query can be slow if the underlying table contains many rows:

SELECT Id 
FROM Document 
WHERE Property1 = 'value'

To improve search performance, Property1 must be indexed if the following circumstances apply:

Table 1. Circumstances necessary for indexing
Circumstance	Comment
Frequent searches	The search is issued frequently, or a quickly returning search is important.
Relative small number of applicable rows	The number of rows that satisfy the search is small relative to the total number of rows in the table.