A METHOD AND APPARATUS FOR QUERY SAMPLING
Original Publication Date: 2000-Nov-01
Included in the Prior Art Database: 2003-Jun-18
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.