Thanx alot... its solved my problem
On Mon, Aug 18, 2008 at 8:50 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> [ please keep the list cc'd for the archives' sake ]
>
> "Gauri Kanekar" <[EMAIL PROTECTED]> writes:
> > On Mon, Aug 18, 2008 at 7:32 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> >> No PG relea
[ please keep the list cc'd for the archives' sake ]
"Gauri Kanekar" <[EMAIL PROTECTED]> writes:
> On Mon, Aug 18, 2008 at 7:32 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> No PG release since 7.3 would have voluntarily planned that query that
>> way. Maybe you were using join_collapse_limit = 1 to
"Gauri Kanekar" <[EMAIL PROTECTED]> writes:
> Following is the Query :
> SELECT sum(id), sum(cd), sum(ad)
>FROM table1 a , table2 b cross join table3 c
>WHERE a.nkey = b.key
> AND a.dkey = c.key
> AND c.date = '2008-02-01'
> AND b.id = 999 ;
Hi,
Following is the Query :
SELECT sum(id), sum(cd), sum(ad)
FROM table1 a , table2 b cross join table3 c
WHERE a.nkey = b.key
AND a.dkey = c.key
AND c.date = '2008-02-01'
AND b.id = 999 ;
We have fired this on our production system which is
