I have a list that includes several lookup fields. Some of these are simple lookups (only one value allowed), others are multi-lookups (the "allow multiple values" checkbox is selected).
I have noticed that these multi-lookup columns have a big impact on performance, retrieving views that include multi-lookups are much slower than views with single lookups.
Are there techniques to make these views faster? For example server side settings, indexing options, etc.?