Le samedi 7 juin 2014 08:35:27 Gurjeet Singh a écrit :
While reading [1] in context of Postgres Hibernator, I see that
Mitsuru mentioned one of the ways other RDBMS allows count(*) to be
driven by an index.
'select /*+ INDEX(emp emp_pk) */ count(*) from emp;' to load index
blocks
I am
On Sat, Jun 7, 2014 at 8:56 AM, Cédric Villemain ced...@2ndquadrant.com wrote:
Le samedi 7 juin 2014 08:35:27 Gurjeet Singh a écrit :
PS: Please note that I am not proposing to add support for the
optimizer hint embedded in Mitsuru's query.
:-)
Even though I (sometimes) favor hints, and
Le samedi 7 juin 2014 09:09:00 Gurjeet Singh a écrit :
On Sat, Jun 7, 2014 at 8:56 AM, Cédric Villemain
ced...@2ndquadrant.com wrote:
Le samedi 7 juin 2014 08:35:27 Gurjeet Singh a écrit :
PS: Please note that I am not proposing to add support for the
optimizer hint embedded in Mitsuru's
On Sat, Jun 07, 2014 at 08:35:27AM -0400, Gurjeet Singh wrote:
While reading [1] in context of Postgres Hibernator, I see that
Mitsuru mentioned one of the ways other RDBMS allows count(*) to be
driven by an index.
'select /*+ INDEX(emp emp_pk) */ count(*) from emp;' to load index blocks