Databases Reference
In-Depth Information
Figure 3.3
Query execution plan for cases 1 and 2.
×
card(shipment.shipdate = '01-JUN-2006') = (1/1,000)
(100,000)
= 100 rows.
These two results are stored as intermediate tables, reduced versions of supplier and
shipment, which we will now call 'supplier' and 'shipment':
card('supplier') = 4 (Note: 'supplier' has 4 rows with city = 'London'.)
