Article View: pl.comp.bazy-danych
Article #194752Re: Relacje w praktyce
From: M.M.
Date: Fri, 18 Dec 2015 12:07
Date: Fri, 18 Dec 2015 12:07
10 lines
2618 bytes
2618 bytes
On Friday, December 18, 2015 at 12:19:35 PM UTC+1, szemrany wrote: > Ten sam test, który w Firebirdzie dał identyczne czasy? Wpatruję się w Twoje zapytania i dochodzę do wniosku że są prawie takie same jak moje. Złączasz jeszcze z trzecią tabelą: 'samochody'. Do samego zliczania to złączenie nie jest potrzebne, dlatego błędnie pomyślałem, że warunek w where dotyczy samochodów :) Czyli zapytania są bardzo podobne do Twoich. Pozdrawiam
Technical Details
Message-ID:
<6f0de78a-ea14-47f9-8229-3df24cff540e@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!mv3no17754734igc.0!news-out.google.com!l1ni7025igd.0!nntp.google.com!mv3no17754723igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<1wybpc8c36lsd$.1fen7ule9h1jh$.dlg@40tude.net> <1tjc7yjmiqguh.11krnzpakf6ri$.dlg@40tude.net> <b79ad5ec-846e-43f5-accf-6eb2f699101d@googlegroups.com> <nk4lort1sib1.kctbavh9wc3g.dlg@40tude.net> <03a7d4b6-93fc-4411-a16b-d09b01180800@googlegroups.com> <6l5i9ybjsi0b$.1dg8u6yw4z4jz$.dlg@40tude.net> <0a73ecf6-e077-41a9-8b13-8334ef196d00@googlegroups.com> <l5s51r5k1n8r$.1c55652qehijb$.dlg@40tude.net> <deab76ac-dc90-41a5-b160-4ab93cbef450@googlegroups.com> <izzsm6fj3oc5$.1huqgrqsag8ft$.dlg@40tude.net> <1ddns001oye6c.1esk5mwsirwbh$.dlg@40tude.net> <0036ff34-efd0-44a5-a3e8-41f86342b9fc@googlegroups.com> <phl63714mm8h.1ccjkrdtm9s44$.dlg@40tude.net> <e24a8b88-d20e-4320-9891-a5d4acfdc6e2@googlegroups.com> <1rta7gv38d1fj.1lxp6ct3432o4.dlg@40tude.net> <eae5303c-2ac1-47bd-8f60-ab2aea63e033@googlegroups.com> <1lllzxba5e7wa.uxteqa2kr9la.dlg@40tude.net> <2d790dfe-83d3-4d1a-871f-04af4459f9f6@googlegroups.com> <8c558b0e-f622-4e50-aa7d-e8fcf40eb30f@googlegroups.com> <htttql88ipmm.g1hlbfzbwpnq.dlg@40tude.net>Show Full Headers
Complete Article Headers
X-Received: by 10.50.18.114 with SMTP id v18mr1669627igd.6.1450440431562; Fri, 18 Dec 2015 04:07:11 -0800 (PST) X-Received: by 10.182.125.195 with SMTP id ms3mr26400obb.17.1450440431532; Fri, 18 Dec 2015 04:07:11 -0800 (PST) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!mv3no17754734igc.0!news-out.google.com!l1ni7025igd.0!nntp.google.com!mv3no17754723igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych Date: Fri, 18 Dec 2015 04:07:11 -0800 (PST) In-Reply-To: <htttql88ipmm.g1hlbfzbwpnq.dlg@40tude.net> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=77.254.47.3; posting-account=xjvq9QoAAAATMPC2X3btlHd_LkaJo_rj NNTP-Posting-Host: 77.254.47.3 References: <1wybpc8c36lsd$.1fen7ule9h1jh$.dlg@40tude.net> <1tjc7yjmiqguh.11krnzpakf6ri$.dlg@40tude.net> <b79ad5ec-846e-43f5-accf-6eb2f699101d@googlegroups.com> <nk4lort1sib1.kctbavh9wc3g.dlg@40tude.net> <03a7d4b6-93fc-4411-a16b-d09b01180800@googlegroups.com> <6l5i9ybjsi0b$.1dg8u6yw4z4jz$.dlg@40tude.net> <0a73ecf6-e077-41a9-8b13-8334ef196d00@googlegroups.com> <l5s51r5k1n8r$.1c55652qehijb$.dlg@40tude.net> <deab76ac-dc90-41a5-b160-4ab93cbef450@googlegroups.com> <izzsm6fj3oc5$.1huqgrqsag8ft$.dlg@40tude.net> <1ddns001oye6c.1esk5mwsirwbh$.dlg@40tude.net> <0036ff34-efd0-44a5-a3e8-41f86342b9fc@googlegroups.com> <phl63714mm8h.1ccjkrdtm9s44$.dlg@40tude.net> <e24a8b88-d20e-4320-9891-a5d4acfdc6e2@googlegroups.com> <1rta7gv38d1fj.1lxp6ct3432o4.dlg@40tude.net> <eae5303c-2ac1-47bd-8f60-ab2aea63e033@googlegroups.com> <1lllzxba5e7wa.uxteqa2kr9la.dlg@40tude.net> <2d790dfe-83d3-4d1a-871f-04af4459f9f6@googlegroups.com> <8c558b0e-f622-4e50-aa7d-e8fcf40eb30f@googlegroups.com> <htttql88ipmm.g1hlbfzbwpnq.dlg@40tude.net> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <6f0de78a-ea14-47f9-8229-3df24cff540e@googlegroups.com> Subject: Re: Relacje w praktyce From: "M.M." <mmarszik@gmail.com> Injection-Date: Fri, 18 Dec 2015 12:07:11 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit