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 <sumit_only@yahoo.com> 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
>
>
>
|