DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=J6RMKvjNu6ZUaKsHVSTba/TJ9q4dDy9ZarWbCdZcvnrDIN1hWXHxnRQ+tYMOhtsM57RO4M3mav1Y34IMAdqqxEztIyoBxQObeLTa0yFLSygZsnxGu6nB/qyUnj+fPKtHPHfTKZSkHjwJ4uuj7Rbv+yuxWZ8zoAfU+OvAAMZQ7k0=;
References: <B097B80F-2D51-4F42-BC0D-5A38CBCD0C01@gmail.com> 
Message-ID: <1385913725.4005.YahooMailNeo@web162901.mail.bf1.yahoo.com>
Date: Sun, 1 Dec 2013 08:02:05 -0800 (PST)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Speed up the query
To: Hengky Liwandouw <hengkyliwandouw@gmail.com>,
 "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
In-Reply-To: <B097B80F-2D51-4F42-BC0D-5A38CBCD0C01@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hengky Liwandouw <hengkyliwandouw@gmail.com> wrote:

> where jualid is not null=20
> and extract(year from tanggal)=3D'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)=3D'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.=A0 That will be interpreted as:

where jualid is not null
=A0=A0 or (returjualid is not null and extract(year from tanggal) =3D '2013=
')

... not:

where (jualid is not null or returjualid is not null)
=A0 and extract(year from tanggal) =3D '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


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance