Optimization Example
SELECT S.Name, E.AnalystName FROM StockQuotes S, Estimations E WHERE S.Name = E.CompanyName AND ClientAnalysis(S.Quotes) = E.Rating
Join
Final
SelProj
UDF
E
S
Join
Final
SelProj
E
S
UDF
Where in the query plan?
Client-Site- or Semijoin?
What is pushed with the UDF?
Previous slide
Next slide
Back to first slide
View graphic version