How to design a database for User Defined Fields?
If performance is the primary concern, I would go with #6… a table per UDF (really, this is a variant of #2). This answer is specifically tailored to this situation and the description of the data distribution and access patterns described. Pros: Because you indicate that some UDFs have values for a small portion of … Read more