CacheLookup
property in standard AX 2012 R3.Problem description
Actually, there is no problem in this post, just some entertainment.
Solution
I analysed
CacheLookup
property on all tables in standard AX 2012 R3 excluding temporary tables and derived tables (CacheLookup
property can't be set on a derived table).The distribution of
CacheLookup
property is presented belowThe majority of tables have Found and NotInTTS. Caching is not enabled on 20% of tables or 1226 tables - there is room for improvement.