I've got the point just now. Hopefully, I had understood it well some weeks
ago. I wrote a brute index and performed some optimizations from inside the
fullScan index according to the where conditions.I did not declare any
other index on the table columns. As mentioned, I just realized now that I
should declare the indexes on the tables and write specific optimizations
for each one.Thanks Thomas.
On Thursday, June 11, 2015 at 4:09:45 PM UTC+2, Pablo Beltran wrote:
>
> Hi,
>
> i would like to get the same text jist like the H2 Web Console when a
> plan is explained (Pls, see the attached picture), but I did not get it yet
> unfortunately.
>
>
>
> Connection conn = ....
>
>
> Statment st = con.createStatment("SELECT * FROM TABLE"),
> st.executeQuery();
>
> ....
>
>
> JdbcConnection jdbcConnection = (JdbcConnection) conn;
> Session session = (Session) jdbcConnection.getSession();
> Command current = session.getCurrentCommand(); //this method has been
> added to the Session class.
> Parser parser = new Parser(session);
> Prepared prepared = parser.prepare(current.toString()); //SELECT * FROM
> TABLE
> Explain exp = new Explain(session);
> exp.setCommand(prepared);
>
> and next??
>
> I've tried several things from here but without too much success.
>
> Any idea?
>
> Thanks in advance!
> Pablo.
>
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
