首页>
外国专利>
Optimizing Database Table Scans in the Presence of Ordered Data
Optimizing Database Table Scans in the Presence of Ordered Data
展开▼
机译:在有序数据的存在下优化数据库表扫描
展开▼
页面导航
摘要
著录项
相似文献
摘要
Optimizing database table scans in presence of SMDO records is provided. An SMDO record corresponding to a most recent span of rows for a column associated with a query predicate is read. It is determined whether a condition for excluding a span of rows is true for the SMDO record based on a type of the query predicate. In response to determining that a condition for excluding a span of rows is not true for the SMDO record, the most recent span of rows is added to a list of spans of rows to scan. It is determined whether a condition for excluding all preceding spans of rows is true for the SMDO record based on the type of the query predicate. In response to determining that a condition for excluding all preceding spans of rows is true for the SMDO record, reading the set of SMDO records is stopped.
展开▼