Location directive tables are found cached, but they are usually accessed using while select statements, so the cache is not utilized. Given the access patterns, and the amount of expected records, then it should be considered to entire table cache them
Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.