1. An optimized query processing system in a database system in a computer system, the optimized query processing system for processing a query to the database system, wherein the database system comprises a table of data and an index correlated to both the query and to the table, the optimized query processing system comprising: an optimizer module to receive a query, the optimizer module to determine whether data responsive to the query has low distinct cardinality; an index accessing module, coupled in communication with the optimizer module, responsive to the optimizer module determining that the data responsive to the query has low distinct cardinality, the index accessing module to access the index to determine if the table contains a first data entry satisfying the query; and a tablescan module, coupled in communication with the index accessing module, responsive to the index accessing module determining that the first entry satisfies the query and prior to determining that a second data entry satisfies the query, the tablescan module to scan substantially the entire table to retrieve substantially all data values satisfying the query.
1. An optimized query processing system in a database system in a computer system, the optimized query processing system for processing a query to the database system, wherein the database system comprises a table of data and an index correlated to both the query and to the table, the optimized query processing system comprising: an optimizer module to receive a query, the optimizer module to determine whether data responsive to the query has low distinct cardinality; an index accessing module, coupled in communication with the optimizer module, responsive to the optimizer module determining that the data responsive to the query has low distinct cardinality, the index accessing module to access the index to determine if the table contains a first data entry satisfying the query; and a tablescan module, coupled in communication with the index accessing module, responsive to the index accessing module determining that the first entry satisfies the query and prior to determining that a second data entry satisfies the query, the tablescan module to scan substantially the entire table to retrieve substantially all data values satisfying the query. 2. The optimized query processing system as claimed in claim 1 , further comprising a query execution plan generation module adapted to generate a query execution plan to cause the index accessing module to access the index to determine if the table contains an entry satisfying the query.