28. The system as recited in claim 26 , wherein the plurality of available optimization modes include Cost based and Rule based modes.
28. The system as recited in claim 26 , wherein the plurality of available optimization modes include Cost based and Rule based modes. 29. The system as recited in claim 28 , wherein the Cost based modes include First_Rows mode and All_Rows mode.