Join Methods: Sort Merge Join

QUERY:

select * from items,stock

where items.total_price=stock.unit_price

Estimated Cost: 19

Estimated # of Rows Returned: 59

1) informix.items: SEQUENTIAL SCAN

SORT SCAN: informix.items.total_price

2) informix.stock: SEQUENTIAL SCAN

SORT SCAN: informix.stock.unit_price

MERGE JOIN

Merge Filters: informix.stock.unit_price = informix.items.total_price

Previous slide

Next slide

Back to first slide

View graphic version