Re: Plan cache

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
> [email protected]
> 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