The present invention is directed to a method and mechanism for
partitioning using information not directly located in the object being
partitioned. According to an embodiment of the invention, foreign
key-primary key relationships are utilized to create join conditions
between multiple database tables to implement partitioning of a database
object. Also, disclosed are methods and mechanisms to perform partition
pruning.