Use of specific fields and tables in queries

You can write more efficient SQL queries by making careful use of certain strategic fields and tables.

mainNodeEntityId field
The mainNodeEntityId field in the entityData table specifies the main node of the entity. This field provides a shortcut to the main node for a particular entity, avoiding the need to traverse the entire containment tree.
entityType field
The entityType field can be used in SQL queries to limit the type of component data that is retrieved.
Protocol endpoint tables
The protocolEndPoint and ipEndPoint tables can be used in SQL queries to identify the IP addresses that are implemented by the device interfaces.

Parent topic: Topology database queries