Index Scans:Upper and Lower Index Filters

QUERY:

select * from stock

where stock_num>=99 and stock_num<=190

Estimated Cost: 1

Estimated # of Rows Returned: 1

1) informix.stock: INDEX PATH

(1) Index Keys: stock_num manu_code

Lower Index Filter: informix.stock.stock_num >= 99

Upper Index Filter: informix.stock.stock_num <= 190

Previous slide

Next slide

Back to first slide

View graphic version