PPT Slide
- ADT methods can be expensive
SELECT Clip(Sharpen(G.Photo), 0,0,100,200)
FROM GeoData G
WHERE G.Region = ‘arctic’
- Optimizations possible
- don’t write intermediate results to disk
- reorder to
- Sharpen(Clip( G.Photo), 0,0,100,200)
- retrieves less from disk *
- reduces cost of Sharpen
-
- traditional database queries are declarative
- no execution plan specified