Hello. Scan index may return all rows from the find() method (but it should also return true from isFindUsingFullTableScan()).
Order of elements in the index is not used in this case if index is not returned from Table.getIndexes(). If you can efficiently lookup rows by values in some columns, you can create additional hash indexes to improve performance of some queries. Hash indexes from Table.getIndexes() aren't used for sorting too. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/8f879994-02d4-449a-990c-1e9949bc5241%40googlegroups.com.
