Methods, computer programs, and database systems for performing a database query to join a column A and a column B on an inequality condition are disclosed. A database includes value-count indexes for columns A and B. Minimum and a maximum values for A and B are determined, using the value-count indexes...http://www.google.fr/patents/US7873629?utm_source=gb-gplus-shareBrevet US7873629 - Dynamic partition enhanced inequality joining using a value-count index
Dynamic partition enhanced inequality joining using a value-count index