In our previous example, if the query processor executes the query in a straight forward way, it would compute this superior relationship for the absolute entire company hierarchy before it figured out which of those people were involved in project X. Now, a really good query processor might actually figure out to fold in a project X but, not necessarily. 