Abstract: A database management optimizer detects patterns in SQL that occur when search conditions are present that represent ranges of values across multiple columns of a table. These patterns are recognized and translated into simpler key value ranges that can be used to provide more efficient use of database indexes.

Abstract: A method for improving the efficiency of queries in relational database management systems that use the exhaustive method of query optimization. The join structure of the query is examined prior to query optimization and tables are ordered according to graph theory. The tables in the FROM clause of the query are then reordered before query optimization. The access plan is thus developed from an already near-optimal table ordering. As a result, the number of table permutations examined during query optimization is pruned, the time to examining large numbers of table order permutations is avoided, and the optimization cost is reduced.

Abstract: Detergent compositions comprising a surfactant system that is either (1) a mixture of zwitterionic detergent surfactant and/or amphoteric (non-zwitterionic) detergent surfactant with nonionic detergent surfactant; or (2) short chain nonionic detergent surfactant; a suds reducing amount of a suds controlling alkoxylated material of the formula: C.sub.n (PO).sub.x (EO).sub.y (PO).sub.z in which C.sub.n is a hydrocarbon group containing n carbon atoms, n is a number from about 6 to about 12, x is a number from about 1 to about 6, y is a number from about 4 to about 15, and z is a number from about 4 to about 25; optional, but preferred, hydrophobic cleaning solvent; and polycarboxylate, especially dicarboxylate, detergent builder, provide superior cleaning of all of the soils commonly found in the bathroom while maintaining a desirable low suds profile and good rinsing properties. The compositions have a pH of from about 1 to about 5.5, preferably from about 2 to about 4 when the dicarboxylate builder is used.

Abstract: Detergent compositions comprising a surfactant system that is either (1) a mixture of zwitterionic detergent surfactant and/or amphoteric (non-zwitterionic) detergent surfactant with nonionic detergent surfactant; or (2) short chain nonionic detergent surfactant; a suds reducing amount of a suds controlling alkoxylated material of the formula: C.sub.n (PO).sub.x (EO).sub.y (PO).sub.z in which C.sub.n is a hydrocarbon group containing, n carbon atoms, n is a number from about 6 to about 12, x is a number from about 1 to about 6, y is a number from about 4 to about 15, and z is a number from about 4 to about 25; optional, but preferred, hydrophobic cleaning solvent; and polycarboxylate, especially dicarboxylate, detergent builder, provide superior cleaning of all of the soils commonly found in the bathroom while maintaining a desirable low suds profile and good rinsing properties. The compositions have a pH of from about 1 to about 5.5, preferably from about 2 to about 4 when the dicarboxylate builder is used.