Dear Forum,
The company I work at uses the SQL Server option with NAV 4.0 SP3. Our database has 4 companies. Our customized Item table has about 15 fields that are used by only 1 company, and for that company, these same fields are used by only about 30% of the currently approx. 7,000 Items in that company. My assumption is that it is inefficient in ways (not enough records per data page, for example) to keep all these fields in the Item table and that I should probably create another table to join to when these fields need to be called upon in reports, etc. Is there an objective way to analyze the benefits in creating another table for the purpose of storing these additional fields? Thanks.