Christian Smith schrieb: > Index the pairs table, like I do in my schema. You might want to index by > id and field as these are primarily what you use to read data in this
Does it make any difference if the index is unique or not? > Now, all lookups used to implement the view are done using index lookups. Can I check that a query use the index? Many thanks Matthias