Глоссарий терминов Oracle
Перевод неподключаемое представление
Описание The optimizer can transform a query block that accesses a nonmergeable view by pushing the query block's predicates inside the view's query. Because the view is defined as a compound query, the optimizer cannot merge the view's query into the accessing query block. Instead, the optimizer can transform the accessing statement by pushing its predicate, the WHERE clause condition (deptno = 20), into the view's compound query.