35
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’.