26. The method of claim 25 , further comprising: generating, at the query optimizer, appropriate recommendations to improve performance based on rules in a knowledge base.
28. The method of claim 26 , wherein each recommendation is associated with a rationale and informative messages for user understandability.