• Very true and I would certainly recommend the same. In this particular case it is a lookup table but not a parent to any other table. It's being used to help calculate some type of rate based on 5 different criteria. It will be read a lot, but not joined to any other tables.

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]