Query Rewriting Using Views

Rewritten query:

SELECT buyer, seller

FROM SeattleView

WHERE product= ‘gizmo’

Original query:

SELECT buyer, seller

FROM Person, Purchase

WHERE Person.city = ‘Seattle’ AND

Person.per-name = Purchase.buyer AND

Purchase.product=‘gizmo’.

Previous slide

Next slide

Back to first slide

View graphic version