Article View: pl.comp.bazy-danych
Article #194323Re: PostgreSQL - jak zbudować optymalne zapytanie?
From: Czarek Grądys
Date: Thu, 12 Mar 2015 12:27
Date: Thu, 12 Mar 2015 12:27
12 lines
1577 bytes
1577 bytes
W dniu 12.03.2015 o 08:48, nkab@toya.net.pl pisze: > if (p1<>NULL and p2=p3) czas wykonania ~0,03 sek > if (p2=p3 and p1<>NULL) czas wykonania ~0,08 sek > Chyba chciałeś napisać: p1 IS NOT NULL -- Cezary Grądys czarekgr@wa.onet.pl
Technical Details
Message-ID:
<55018614$0$2210$65785112@news.neostrada.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!goblin1!goblin.stu.neva.ru!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-a-02.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mailReferences:
<mci51m$dju$1@news.icm.edu.pl> <fk06sb-jtf.ln1@depesz.com> <mctd2q$q6k$1@news.icm.edu.pl> <5bb452da-87e3-46b6-bbe4-51cd8e95fc73@googlegroups.com> <c57ea06e-2252-4f0c-ad4b-a2a2fed94ac4@googlegroups.com> <ef9d0ff9-dc2b-4ce1-845d-2f080e919ebd@googlegroups.com> <27b8c3e2-f0d5-4667-a74a-09a11cbeb915@googlegroups.com> <2330ae3c-1ffb-4e8a-8327-3a7cb9cebc0b@googlegroups.com>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!goblin1!goblin.stu.neva.ru!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-a-02.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mail Date: Thu, 12 Mar 2015 13:27:00 +0100 From: Czarek Grądys <czarekgr@wa.onet.pl> User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 Newsgroups: pl.comp.bazy-danych Subject: Re: PostgreSQL - jak zbudować optymalne zapytanie? References: <mci51m$dju$1@news.icm.edu.pl> <fk06sb-jtf.ln1@depesz.com> <mctd2q$q6k$1@news.icm.edu.pl> <5bb452da-87e3-46b6-bbe4-51cd8e95fc73@googlegroups.com> <c57ea06e-2252-4f0c-ad4b-a2a2fed94ac4@googlegroups.com> <ef9d0ff9-dc2b-4ce1-845d-2f080e919ebd@googlegroups.com> <27b8c3e2-f0d5-4667-a74a-09a11cbeb915@googlegroups.com> <2330ae3c-1ffb-4e8a-8327-3a7cb9cebc0b@googlegroups.com> In-Reply-To: <2330ae3c-1ffb-4e8a-8327-3a7cb9cebc0b@googlegroups.com> Lines: 12 Message-ID: <55018614$0$2210$65785112@news.neostrada.pl> Organization: Telekomunikacja Polska NNTP-Posting-Host: 83.28.154.240 X-Trace: 1426163220 unt-rea-a-01.news.neostrada.pl 2210 83.28.154.240:36441 X-Complaints-To: abuse@news.neostrada.pl Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit