PPT Slide
Predicate Ordering in Table Accesses
Select rtime = 1
Select veg(raster) > 50
Scan rasters
Scan rasters
Select rtime = 1
Select veg(raster) > 50
- ¥
- 0.001
- ¥
- 0.001
selectivity - 1
differntial cost
rank =
CPU Execution Time: 2 min 18.09 sec 0 min 0.03 sec
CPU Optimization Time: 0.01 sec 0.10 sec
Previous slide
Next slide
Back to first slide
View graphic version