Article View: pl.comp.lang.delphi.bazy-danych
Article #70587MySQL - optymalizacja zapytania
From: webcm123
Date: Tue, 07 Aug 2007 20:43
Date: Tue, 07 Aug 2007 20:43
4 lines
1404 bytes
1404 bytes
http://phpfi.com/254953 Dlaczego MySQL nie wykorzystuje indeksów w tabeli f3s_news? Da się jakoś to zapytanie zoptymalizować? Przecież pole "cat" jest indeksem.
Technical Details
Message-ID:
<1186519394.193961.18510@g4g2000hsf.googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!news.uni-stuttgart.de!news.belwue.de!news.tiscali.de!newsfeed.freenet.de!feeder.news-service.com!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!g4g2000hsf.googlegroups.com!not-for-mailShow Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!news.uni-stuttgart.de!news.belwue.de!news.tiscali.de!newsfeed.freenet.de!feeder.news-service.com!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!g4g2000hsf.googlegroups.com!not-for-mail From: webcm123@gmail.com Newsgroups: pl.comp.lang.delphi.bazy-danych Subject: MySQL - optymalizacja zapytania Date: Tue, 07 Aug 2007 13:43:14 -0700 Organization: http://groups.google.com Lines: 5 Message-ID: <1186519394.193961.18510@g4g2000hsf.googlegroups.com> NNTP-Posting-Host: 195.117.54.121 Mime-Version: 1.0 X-Trace: posting.google.com 1186519394 24866 127.0.0.1 (7 Aug 2007 20:43:14 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 7 Aug 2007 20:43:14 +0000 (UTC) User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 w3cache.stella.net.pl:8080 (squid/2.6.STABLE6) Complaints-To: groups-abuse@google.com Injection-Info: g4g2000hsf.googlegroups.com; posting-host=195.117.54.121; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit