5. A program product, comprising: a program code configured upon execution to: generate an access plan for a query using a cost-based optimizer; subsequent to generation of the access plan by the cost-based optimizer, receive one or more user preferences relating to the access plan, wherein the one or more user preferences are separate from the query and received from a user subsequent to generation of the access plan; associate the one or more preferences with the access plan; store the access plan and the associated one or more user preferences such that the access plan may be modified prior to execution by applying the one or more user preferences to the access plan; execute the access plan to generate a result set and apply the one or more user preferences to the access plan to modify the access plan prior to execution such that the modified access plan is executed; and, wherein the one or more user preferences include an additional SQL clause to append to the access plan, and wherein the program code is configured to apply the one or more user preferences to the access plan by merging the query with the additional SQL clause to generate a new access plan and executing the new access plan; and a recordable type medium storing the program code.
6. The program product of claim 5 , wherein the SQL clause is selected from a group consisting of an Order By clause, a Group By clause, and an Optimize clause.