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

Symptoms

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

Resolution

Back porting from Rainer.

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 4010581 - Last Review: 2017, ജനു 23 - Revision: 1

ഫീഡ്‌ബാക്ക്