Browse Prior Art Database

A METHOD AND APPARATUS FOR QUERY SAMPLING

IP.com Disclosure Number: IPCOM000013582D
Original Publication Date: 2000-Nov-01
Included in the Prior Art Database: 2003-Jun-18

Publishing Venue

IBM

Abstract

A METHOD AND APPARATUS FOR QUERY SAMPLING Queries against files or databases used for decision support or business intelligence can take many minutes, up to days, to complete. This can be due to very large objects (tables or indices) being accessed or due to complex queries requiring joins between many tables which may involve sorting intermediate results. Sometimes, an exact result set is not necessary from long-running queries. Sometimes, a "rough guess" is adequate. This invention provides a means to reduce the elapsed time for queries by "skipping" a specified quantity of data to be accessed by the query.