[Roboprog]

For an (SQL) database, you would want to look at something called a query planner (e.g. - "explain" command).

It describes the order that tables are accessed, which indices (if any) are used for each access, "and so on".