Tuning Datadictionary

Performance suffers unless care has been taken in creating the CA Datacom Datadictionary definitions that are used by CA Dataquery.

Entity-occurrence names should be different for TABLE, KEY, and FIELD entity-occurrences so that CA Dataqueryy can unambiguously resolve references in queries.
Choose names that are obvious and meaningful to CA Dataquery users.
Each table should have at least one unique key defined for it.
No two keys in the same row should have the same value for the KEY-ID.
Equivalent keys in different tables should be defined similarly. That is, the order, length, and type of constituent columns should be the same.
Equivalent fields or keys in different tables should be named the same to avoid confusion and to facilitate relating rows together.