1. A process, executed by at least one processor in a database system, of parsing a database query, comprising: transforming, by the at least one processor, the database query containing at least one user-defined data type method into a statement; and removing, by the at least one processor, redundant invocations of the at least one user-defined data type method in transforming the database query to the statement.
1. A process, executed by at least one processor in a database system, of parsing a database query, comprising: transforming, by the at least one processor, the database query containing at least one user-defined data type method into a statement; and removing, by the at least one processor, redundant invocations of the at least one user-defined data type method in transforming the database query to the statement. 8. The process of claim 1 , wherein the database query contains plural set clauses, the method further comprising grouping the set clauses according to columns of a table.