23. The system of claim 22 , wherein the search engine builds a left deep nested loop join tree based on selecting a subplan having favorable execution costs from each class.
22. The system of claim 21 , wherein the search engine groups said subplans into classes based on tables covered by each subplan.