At present for reporting I use following types of query:
select crm.*, crm_cnt.cnt
(select count(*) as cnt from crm) crm_cnt;
Here count query is used to find the total number of records.
Same FROM clause is copied in both the part of the query.
Is there any other good alternative way to get this similar value?
pgsql-performance by date
|Next:||From: Samuel Gendler||Date: 2010-10-18 06:13:01|
|Subject: Re: No hash join across partitioned tables?|
|Previous:||From: Merlin Moncure||Date: 2010-10-16 19:54:14|
|Subject: Re: Stored procedure declared as VOLATILE => no good
optimization is done|