1. A method for rewriting Structured Query Language (SQL) statements, the method comprising: a computer receiving an SQL statement having search criteria that pertains to a plurality of fields in a plurality of database tables; the computer creating a first table from the SQL statement that lists all different combinations of the search criteria in the SQL statement, each of the combinations comprising one or more values of respective one or more fields of the database tables; the computer dividing the first table into an initial set of temporary tables, each of the temporary tables comprising the combinations of one or more values of a same one or more fields in the first table; the computer individually joining each temporary table of the initial set of temporary tables with the SQL statement, and generating a new set of temporary tables, each temporary table of the new set comprising results of a search conducted using a respective SQL query formed from the individually joining of a respective temporary table of the initial set with the SQL statement; and the computer combining results from the new set of temporary tables into a second table.
1. A method for rewriting Structured Query Language (SQL) statements, the method comprising: a computer receiving an SQL statement having search criteria that pertains to a plurality of fields in a plurality of database tables; the computer creating a first table from the SQL statement that lists all different combinations of the search criteria in the SQL statement, each of the combinations comprising one or more values of respective one or more fields of the database tables; the computer dividing the first table into an initial set of temporary tables, each of the temporary tables comprising the combinations of one or more values of a same one or more fields in the first table; the computer individually joining each temporary table of the initial set of temporary tables with the SQL statement, and generating a new set of temporary tables, each temporary table of the new set comprising results of a search conducted using a respective SQL query formed from the individually joining of a respective temporary table of the initial set with the SQL statement; and the computer combining results from the new set of temporary tables into a second table. 2. The method of claim 1 , further comprising the computer searching the second table.