Hi,
I'm using H2 1.4.192 as part of the dropwizard container.
I've tried to use multiple indexes in order to be able to answer a complex
query(multiple where parameter)
It seems that H2 pick one index.
I verified it by running EXPLAIN ANALYZE
In response I saw one index:
/* PUBLIC.STATE_IDX: STATE IN(?2, ?3, ?4) */
my questions are:
1. how does he pick the inde (if i hvae multiple)
2. how to make h2 use the multiple indexes? I must use it for queries on
big data.
thx
Elad Wertzberger
--
This message may contain confidential and/or privileged information.
If you are not the addressee or authorized to receive this on behalf of the
addressee you must not use, copy, disclose or take action based on this
message or any information herein.
If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Thank you.
--
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.
