

Tuning Your System for CA Dataquery › Tuning Datadictionary
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.
Copyright © 2014 CA.
All rights reserved.
 
|
|