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.