Article View: pl.comp.bazy-danych
Article #194729Re: Relacje w praktyce
From: M.M.
Date: Mon, 14 Dec 2015 11:08
Date: Mon, 14 Dec 2015 11:08
13 lines
2232 bytes
2232 bytes
On Saturday, December 12, 2015 at 10:01:33 PM UTC+1, szemrany wrote: > Chodziło o zwykłe: > > select L.imie, L.Nazwisko, count(z.id) as liczba_samochodow from Ludzie L > join zasoby z on z.id_1 = L.id > join samochody s on s.id = z.id_2 > group by L.imie, L.nazwisko Nie odpowiedziałeś, a wyjątkowo bardzo zależy mi na odpowiedzi. Więc ponawiam pytanie: jakie jest uzasadnienie, że Twoje zapytanie będzie szybsze? Pozdrawiam
Technical Details
Message-ID:
<f0a8d25b-e441-48b6-9c3b-7bad3b83fccd@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news.glorb.com!mv3no15961648igc.0!news-out.google.com!f6ni22580igq.0!nntp.google.com!mv3no15961643igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<1wybpc8c36lsd$.1fen7ule9h1jh$.dlg@40tude.net> <6afe3f6d-b8e9-46af-a682-e1f741c1de22@googlegroups.com> <n4e4mk$sr7$1@usenet.news.interia.pl> <df04af2d-5b69-4906-a05e-ce9bf9af9b07@googlegroups.com> <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>Show Full Headers
Complete Article Headers
X-Received: by 10.67.5.169 with SMTP id cn9mr27922494pad.0.1450091297439; Mon, 14 Dec 2015 03:08:17 -0800 (PST) X-Received: by 10.182.250.169 with SMTP id zd9mr382650obc.1.1450091297390; Mon, 14 Dec 2015 03:08:17 -0800 (PST) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news.glorb.com!mv3no15961648igc.0!news-out.google.com!f6ni22580igq.0!nntp.google.com!mv3no15961643igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych Date: Mon, 14 Dec 2015 03:08:17 -0800 (PST) In-Reply-To: <izzsm6fj3oc5$.1huqgrqsag8ft$.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> <6afe3f6d-b8e9-46af-a682-e1f741c1de22@googlegroups.com> <n4e4mk$sr7$1@usenet.news.interia.pl> <df04af2d-5b69-4906-a05e-ce9bf9af9b07@googlegroups.com> <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> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <f0a8d25b-e441-48b6-9c3b-7bad3b83fccd@googlegroups.com> Subject: Re: Relacje w praktyce From: "M.M." <mmarszik@gmail.com> Injection-Date: Mon, 14 Dec 2015 11:08:17 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit