Processing Queries with Views

• For logically stored views, use query modification:

  • Could be rewritten (modified):
  • or:

SELECT Y.*

FROM YoungActiveStudents Y

WHERE Y.name = ‘Sam’

SELECT Y.*

FROM ( <view definition goes here> ) AS Y

WHERE Y.name = ‘Sam’

SELECT S.name, E.grade

FROM Students S, Enrolled E

WHERE S.sid = E.sid and S.age < 21 and S.name = ‘Sam’

Previous slide

Next slide

Back to first slide

View graphic version