'A b a queries' diaporamas de présentation

Query Optimization, part 2

335 views • 24 slides

Query Optimization

sname. rating > 5. bid=100 . (Simple Nested Loops). sid=sid. Sailors. Reserves. Query Optimization. Goal:. Declarative SQL query. Imperative query execution plan:. SELECT S.sname FROM Reserves R, Sailors S WHERE R.sid=S.sid AND R.bid=100 AND S.rating>5.

807 views • 17 slides

Query Optimization

sname. rating > 5. bid=100. (Simple Nested Loops). sid=sid. Sailors. Reserves. Query Optimization. Goal:. Declarative SQL query. Imperative query execution plan:. SELECT S.sname FROM Reserves R, Sailors S WHERE R.sid=S.sid AND R.bid=100 AND S.rating>5.

230 views • 17 slides