Yes, they are. Any lookup field is indexed (case insensitively) in the lookup table as well as its FK values, hence the query engine will use it. See closely my post about the lookup fields.JohnFredC wrote:I think camera make and model should be indexed.
Thanks for the hint tough.