Plan cache

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Plan cache

dman
Hi folks,

I'm using HSQLDB in my projects.

Does HSQLDB has a cache of query plans?

Is it possible to see if the same plan used for queries like
select column1,column2 from table where column3 = 1234
and
select column1,column2 from table where column3 = 2345

Thanks,
Slava
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Plan cache

Fred Toussi-2
You can use EXPLAIN PLAN FOR SELECT .... to see the query plan.

The two examples you quoted will always use the same plan.

Fred

On Sat, Apr 6, 2013, at 15:30, dbmaster wrote:

> Hi folks,
>
> I'm using HSQLDB in my projects.
>
> Does HSQLDB has a cache of query plans?
>
> Is it possible to see if the same plan used for queries like
> select column1,column2 from table where column3 = 1234
> and
> select column1,column2 from table where column3 = 2345
>
> Thanks,
> Slava
>
>
>
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/Plan-cache-tp3873.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for
> building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> Hsqldb-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Loading...