Hi Sumit, Phoenix doesn't cache query plans as of yet. Once we move over to Calcite parser and optimizer (which is a work in progress), we will hopefully start doing that which is when your suggested approach of using PreparedStatement with bind params would be beneficial.
- Samarth On Mon, Sep 14, 2015 at 9:13 PM, Sumit Nigam <[email protected]> wrote: > Hello, > > I am using Phoenix 4.5 with Hbase 0.98.1. > > PreparedStatement is preferred in case of say Oracle, etc. to help with > effective use of query plans (with bind params). Does it also have same > guarantees with Phoenix or does the Phoenix query engine treat both > Statement and Prepared statement equally and I can use any of these with > similar performance characteristics? > > Thanks, > Sumit > > >
