[h2] Re: Query Optimizer limitations
Also, if you can, try loading the data into another DB and running the same querry. This will give you an idea if it is a problem with how you are using H2, or if it is just a hard query for most engines to optimize. Also, you may get faster results if you use the H2 PageStore engine. On Thursday, January 19, 2017 at 3:26:21 PM UTC-5, Adam McMahon wrote: > > As far as I am aware, the problem with the query optimizer is that it does > not use indexs in every situation that one might expect. But yours seems > to be using the index. So, I don't know what else it could be (but I am no > expert at H2). > > How long does it take to run the query? How many rows are there, and what > is the general size of the rows (number of columns)? > > > > On Thursday, January 19, 2017 at 5:47:55 AM UTC-5, Anil Dasari wrote: >> >> Hi Adam, >> >> I mean query is very slow. Explain plan looks good and it is using index. >> I did not compare with other databases. >> >> 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Query Optimizer limitations
As far as I am aware, the problem with the query optimizer is that it does not use indexs in every situation that one might expect. But yours seems to be using the index. So, I don't know what else it could be (but I am no expert at H2). How long does it take to run the query? How many rows are there, and what is the general size of the rows (number of columns)? On Thursday, January 19, 2017 at 5:47:55 AM UTC-5, Anil Dasari wrote: > > Hi Adam, > > I mean query is very slow. Explain plan looks good and it is using index. > I did not compare with other databases. > > 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Query Optimizer limitations
Hi Adam, I mean query is very slow. Explain plan looks good and it is using index. I did not compare with other databases. 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Query Optimizer limitations
Hi, when you say performance is very bad, what do you mean? What is slow to you? By slow, do you mean slow compared to other databases? Does it use index? Do you expect the querry to use an index that it is not using (try the explain method to learn about what the query is doing behind the scenes). On Tuesday, January 17, 2017 at 12:20:26 PM UTC-5, Anil Dasari wrote: > > Hi, > > I have created a simple join query between two tables and performance is > very bad. > > I read the documentation and understand that query optimizer have some > limitations. i would like to go thorough them before actually posting the > my query having the issues. > > Could you please point me to the query optimizer limitations ? thanks. > > 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.