UTILIZING HIERARCHY METADATA TO IMPROVE PATH SELECTION

Embodiments are directed to implementing hierarchy metadata to improve relational model default path selection heuristics. A computer system receives a database query from a user. The query is configured to return a portion of requested data stored in the database. The database includes multiple different data entities related to each other via different relationship paths. The computer system accesses hierarchy metadata that describes various database hierarchies, each hierarchy including multiple data entities. The computer system determines an optimal path between the related data entities based on the database query and the hierarchy metadata, and accesses the data using the determined optimal data entity relationship path.