From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
---|---|
To: | Hengky Liwandouw <hengkyliwandouw(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Speed up the query |
Date: | 2013-12-01 16:02:05 |
Message-ID: | 1385913725.4005.YahooMailNeo@web162901.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hengky Liwandouw <hengkyliwandouw(at)gmail(dot)com> wrote:
> where jualid is not null
> and extract(year from tanggal)='2013')
> But the problem is : when i change the where clause to :
>
> where jualid is not null or returjualid is not null
> and extract(year from tanggal)='2013')
>
> (there is additional or returjualid is not null,) the query needs
> 56 second to display the result.
Before worrying about the run time, I would worry about whether you
are getting the results you expect. That will be interpreted as:
where jualid is not null
or (returjualid is not null and extract(year from tanggal) = '2013')
... not:
where (jualid is not null or returjualid is not null)
and extract(year from tanggal) = '2013'
AND has higher priority than OR; so if you want to limit by year
from tanggal even when jualid is not null, you must use
parentheses.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Hengky Lie | 2013-12-01 16:14:38 | Re: Speed up the query |
Previous Message | Hengky Liwandouw | 2013-12-01 14:11:40 | Re: Speed up the query |