For some simple queries, the necessary indexes can be easily identified and readily created with the administration console.
SELECT Id
FROM Document
WHERE Property1 = 'value'
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. |