In response to Jignesh Shah :
Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
associated with prepared query(not table) to improve performance of building
query. I just need to find plan using statement ID and execute it. I don't
know
how to do this.
Please, answer
you can create a primary key to associate with each row in the table
On 10/12/09, A. Kretschmer andreas.kretsch...@schollglas.com wrote:
In response to Jignesh Shah :
Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
associated with prepared query(not table) to improve
Hi,
Could any one please tell me what is statement ID of table? How to get it
and in which scenarios it can be helpful? Any documentation or example about
statement ID would also really helpful for me.
Thanks,
Jignesh
In response to Jignesh Shah :
Hi,
Could any one please tell me what is statement ID of table?
There isn't such ID, but every table has an OID, an Object Identifier.
How to get it and
The (hidden) column oid of pg_class contains this OID.
in which scenarios it can be helpful? Any
Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
associated with prepared query(not table) to improve performance of building
query. I just need to find plan using statement ID and execute it. I don't
know how to do this.
Thanks,
Jignesh
On Sun, Oct 11, 2009 at 8:06 PM,