首页>
外国专利>
Method and apparatus for eliminating partitions of a database table from a join query using implicit limitations on a partition key value
Method and apparatus for eliminating partitions of a database table from a join query using implicit limitations on a partition key value
展开▼
机译:使用对分区键值的隐式限制从联接查询中消除数据库表分区的方法和装置
展开▼
页面导航
摘要
著录项
相似文献
摘要
A database facility supports database join queries in a database environment having at least one database table divided into multiple partitions based on a partition key value. The facility determines whether the values in a table joined to the partitioned table place an implicit limitation on the partition key, and eliminates from query evaluation any partitions which do not satisfy the implicit limitation. Preferably, the database uses a star schema organization, in which implicit limitations in a relatively small dimension table are used to eliminate partitions in a relatively large fact table.
展开▼