This advice is often given by GCS (see here, there)
We'd like to avoid sledgehammer approaches to solving problems. And we need people to understand what these mean.
Some of these tables are queryable in SMA, but they're in different places, with different names. (e.g., on the Application Based Assembly Cache Management tab, under Database reports, when I click Entries, I see a reference to DatabaseACEntryCacheReport. Is this the pr_assembledclasses table?
Can we have (or can someone build) an interface in SMA (or other tool) which displays, for each table (or cache)
Jon, whether to clear caches or which caches to clear depends on what issue is being worked on. Can you please say a bit more about what your symptom is ? Is it "wrong rule picked after importing something" or "wrong rule picked occasionally without knowing what causes it" or what is your particular symptom ?