Our study has a lot of lookups defined on the datasets. The majority of these lookups point to simple one-column tables that are used solely to generate a combobox that restricts allowable values for data entry.

My understanding of how labkey works is that whenever you load a dataset, if there is a lookup labkey will auto-join to that table in order to find the display value for that field. Much of the time this make sense since the stored value does not equal the display value. However, in the above situation it doesnt, and it potentially adds a lot of overhead. First, is that assumption about lookups and labkey SQL correct (each lookup always results in a join)? If that is true, can it be avoided?

Thanks.