A method and system for performing partition pruning for queries that include a non-single table predicate is disclosed. According to an embodiment of the invention, this type of query is processed by performing a transformation of the query to include additional predicates comprising subqueries. The transformed query includes single table predicates on the partitioning column of the table being queried, based upon join predicates that exist in the original query.

 
Web www.patentalert.com

< FIber optic apparatus for switching electrical loads

< Integrated manufacture of side-polished fiber optics

> Techniques for granting shared locks more efficiently

> Apparatus for generating random numbers

~ 00221