DPA Repo ERD

If you open a support case, they should be able to share the repo ERD with you as well as a brief description for CONSW and CONSS. CONSW especially can be a bit cryptic.

This is what i have with me. Hope this helps

Please find below table details/information.

CONSW : It is the master table for referring sqlhash and planhashes and other stats. It stores only 30 days of data
CONSPT : it stores the plan details of queries for SQL Server
CONSS : stores the statistics of queries
CONST stores sql text of all the normalized queries
CONST-EXAMPLE : Stores one example each of the normalized queries