Typically, you need to qualify only the highest object in the selection with the model ID. For example, if entity types and their attributes are being selected, qualify entity type within model and attribute within entity type. For performance reasons, it may be advantageous to qualify all views with model ID, if the join limits permit.
Important! If both entity type and attribute are qualified by model ID, but attribute is not qualified by entity type, a Cartesian product of the two views results: The number of rows returned is the product of the number of rows selected from each view.
|
Copyright © 2013 CA.
All rights reserved.
|
|