1. A computer implemented method for rewriting view statements in Structured Query Language (SQL) statements, the method comprising the steps of: a computer receiving a SQL statement with a full select portion having a reference to a view that contains a join operation; in response to the full select portion having a reference to a view that contains a join operation, the computer moving the reference to the view out of the full select portion; the computer resolving the view and the join operation separately from the SQL statement, and the computer creating in memory a temporary table with a result of the resolving; and the computer inserting a reference to the temporary table, instead of the result of the resolving, in the full select portion.