Hi, first, thanks for all the people who work on H2. I am experimenting the following:
~500 ms for query: SELECT * FROM OFBIZ.INVOICE IN WHERE IN.INVOICE_DATE > TIMESTAMP'2015-03-17 20:31:59.131' ~ 50 ms for query: SELECT * FROM OFBIZ.INVOICE IN WHERE IN.INVOICE_DATE < TIMESTAMP'2015-03-17 20:31:59.131' The only difference is that in one query I am using GREATER THAN and in the other LESS THAN. I have tried creating indexes: - no indexes at all on that field (INVOICE_DATE) - ASC and DESC indexes on the field - only DESC index I get the same query time for all scenarios. Does indexes help if 'greater than' or 'less than' is used? If 'WHERE NOT' is used with less than, the same thing. Any ideas or suggestions? Thanks! -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
