If the information selected e.g. department, is not dependent upon anything else, i.e., the information is isolated, and the other objects that are dependent upon department have been declared as optional, then those objects are eliminated from the query, via query rewrite, and it is as though the view had been written with only departments.