MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Notifier 1.1.8 has been released 08/23/2019 10:11AM

Advanced Search
New Topic
Pages:
« 1
...
14 15 16 17 18

Subject
Views
Written By
Posted
subquery workaround in MySQL 4.0.24  
2,486
Robert van Twillert
02/13/2006 12:47PM
SUBQUERY PROBLEM  
2,986
Odimar Tomazeli
02/07/2006 04:21PM
Re: SUBQUERY PROBLEM  
1,905
Odimar Tomazeli
02/13/2006 12:16PM
Re: SUBQUERY PROBLEM  
2,062
Odimar Tomazeli
02/13/2006 11:17AM
Re: SUBQUERY PROBLEM  
1,959
Jay Pipes
02/13/2006 11:22AM
Re: SUBQUERY PROBLEM  
2,120
Odimar Tomazeli
02/13/2006 11:06AM
Re: SUBQUERY PROBLEM  
1,958
Odimar Tomazeli
02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team  
1,962
Odimar Tomazeli
02/08/2006 10:26AM
Re: SUBQUERY PROBLEM  
2,019
Robin Schumacher
02/08/2006 04:57AM
Re: SUBQUERY PROBLEM  
1,894
Jay Pipes
02/08/2006 03:59PM
Re: SUBQUERY PROBLEM  
2,012
Jay Pipes
02/07/2006 04:45PM
Re: SUBQUERY PROBLEM  
1,919
Jay Pipes
02/07/2006 04:52PM
Subqueries too slow  
5,014
Andreas Schlicker
02/06/2006 11:08AM
Re: Subqueries too slow  
2,081
Andreas Schlicker
02/10/2006 09:49AM
Re: Subqueries too slow  
2,228
Jay Pipes
02/10/2006 10:43AM
Re: Subqueries too slow  
2,346
Andreas Schlicker
02/10/2006 03:18AM
Re: Subqueries too slow  
2,012
Jay Pipes
02/10/2006 08:51AM
Re: Subqueries too slow  
2,319
Andreas Schlicker
02/07/2006 08:38AM
Re: Subqueries too slow  
2,329
Robin Schumacher
02/06/2006 02:17PM
Re: Subqueries too slow  
2,302
Andreas Schlicker
02/07/2006 07:06AM
Re: Subqueries too slow  
2,528
Jay Pipes
02/06/2006 11:54AM
Is this query optimized?  
2,231
zaw sze
02/09/2006 09:44PM
Question about Handler_write  
3,013
Sebastien Caisse
02/09/2006 09:42AM
clash between unique and index keys  
5,591
Kenneth Vogt
02/08/2006 12:58AM
Re: clash between unique and index keys  
2,295
Kenneth Vogt
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,540
Jay Pipes
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,325
Kenneth Vogt
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,468
Jay Pipes
02/08/2006 05:49PM
qcache_free_blocks  
7,928
Jacky Shu
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,683
Jay Pipes
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,037
Jacky Shu
02/07/2006 12:13PM
optimize  
2,840
edson fernando
01/17/2006 02:41PM
Re: optimize  
1,878
Sebastien Caisse
02/02/2006 09:02AM
Re: optimize  
1,911
edson fernando
01/18/2006 09:07AM
Re: optimize  
1,897
KimSeong Loh
01/17/2006 06:48PM
Double Index Performance  
7,855
Jawad Laraqui
01/12/2006 02:21PM
Re: Double Index Performance  
2,632
Sebastien Caisse
01/16/2006 06:24AM
Re: Double Index Performance  
2,693
Björn Steinbrink
01/16/2006 08:46AM
Re: Double Index Performance  
2,340
Sebastien Caisse
01/17/2006 06:45AM
Re: Double Index Performance  
2,542
Sebastien Caisse
02/01/2006 01:05PM
Re: Double Index Performance  
3,033
Björn Steinbrink
01/13/2006 05:18PM
'where' with 'in' doesn't use index?  
2,822
Vlado Kurelec
01/24/2006 05:25AM
Re: 'where' with 'in' doesn't use index?  
2,028
Vlado Kurelec
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
1,923
Robin Schumacher
01/30/2006 04:45PM
subquery breaks optimization  
2,571
Kiryll Mirnenko
01/20/2006 06:51AM
Re: subquery breaks optimization  
1,883
Robin Schumacher
01/24/2006 07:14PM
mysql dont use my Index?  
2,603
Johannes Fosseus
01/12/2006 08:22AM
Re: mysql dont use my Index?  
1,869
Jay Pipes
01/18/2006 10:36PM
does Select values effect index selection?  
2,744
ade br
01/10/2006 09:30AM
Re: does Select values effect index selection?  
1,862
Jay Pipes
01/10/2006 05:04PM
Optimizing with DATE()  
2,650
Paul Hartman
01/03/2006 02:28PM
Re: Optimizing with DATE()  
1,886
KimSeong Loh
01/03/2006 06:53PM
Simple Query - but explain worries me  
2,950
Jake Day
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,050
Jake Day
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
1,970
Konstantin Osipov
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,034
Vangelis Katsikaros
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
1,926
Jake Day
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
2,013
Vangelis Katsikaros
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
1,955
Jake Day
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
2,020
Jake Day
11/01/2005 08:03AM
select distinct slower in 5.0 than 4.1  
3,005
Saar Barhoom
12/18/2005 12:24PM
Re: select distinct slower in 5.0 than 4.1  
2,064
KimSeong Loh
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,036
Peter Zaitsev
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,087
Saar Barhoom
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,117
Timour Katchaounov
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,394
Jay Pipes
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,150
Saar Barhoom
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,075
Jay Pipes
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,082
Saar Barhoom
12/21/2005 01:54AM
Range Join Performance  
3,915
Lionel Horn
11/23/2005 08:47AM
Re: Range Join Performance  
2,112
Jay Pipes
12/26/2005 07:56PM
Re: Range Join Performance  
2,097
Igor Babaev
12/21/2005 11:10PM
does my index take effect?  
2,991
zhenxing zhai
12/21/2005 03:19AM
Re: does my index take effect?  
1,896
Igor Babaev
12/21/2005 11:03PM
Index merge optimization with joined tables?  
3,224
Kayra Otaner
12/01/2005 11:39AM
Re: Index merge optimization with joined tables?  
1,995
Igor Babaev
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,138
Brian Moon
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,148
Jay Pipes
12/07/2005 05:37PM
explain + straight join oddity  
8,592
Stuart Maclean
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,543
Igor Babaev
12/21/2005 10:44PM
Can't get my indexes right  
3,094
Tobias Ritzau
11/26/2005 04:53PM
Re: Can't get my indexes right  
2,009
Igor Babaev
12/21/2005 10:34PM
Re: Can't get my indexes right  
2,010
Tobias Ritzau
11/28/2005 02:19PM
Re: Can't get my indexes right  
1,897
Tobias Ritzau
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,144
KimSeong Loh
11/28/2005 03:17AM
Re: Can't get my indexes right  
1,953
Tobias Ritzau
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,070
KimSeong Loh
11/27/2005 07:28PM
optimization of left outer joins  
4,302
Clive Cox
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,103
Igor Babaev
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,515
Jay Pipes
12/16/2005 10:23AM
MySQL 5.0 optimizer: loose scans  
2,719
Edwin DeSouza
12/19/2005 01:46PM
Query Optimizer / SQL Translation  
3,901
Dave Wilson
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,260
Timour Katchaounov
12/14/2005 02:55AM
Group by Optimization  
6,749
Joe Genshlea
12/01/2005 08:27AM
Re: Group by Optimization  
7,335
Timour Katchaounov
12/14/2005 02:36AM
Re: Group by Optimization  
3,141
Jay Pipes
12/05/2005 11:29AM
Re: Group by Optimization  
3,685
Björn Steinbrink
12/03/2005 06:07AM
Re: Group by Optimization  
3,306
Jay Pipes
12/05/2005 11:32AM
Re: Group by Optimization  
3,176
Björn Steinbrink
12/09/2005 04:53PM
How to force the optimizer to use an index in a sub-query?  
6,513
Natalia Kuznesov
10/27/2005 10:43AM
Re: How to force the optimizer to use an index in a sub-query?  
3,419
Francisco Wong-Li
12/01/2005 01:51PM
why don't work for my substring index?  
4,125
zhenxing zhai
11/06/2005 10:09PM
Re: why don't work for my substring index?  
2,586
Francisco Wong-Li
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,466
zhenxing zhai
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,431
Felix Geerinckx
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,275
zhenxing zhai
11/09/2005 03:07AM
fast retrieval from MySQL database  
2,873
Akasmika Dash
11/21/2005 05:07AM
WHERE clause processing  
2,773
Maxx Kazimieszko
11/15/2005 05:20PM
Re: WHERE clause processing  
1,960
KimSeong Loh
11/15/2005 07:32PM
Eternal SELECT queries  
3,061
Aniceto Perez
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,086
Felix Geerinckx
11/15/2005 09:20AM
Performance of Select (pk) vs Select(*) with order by  
4,716
Alexander Hristov
11/07/2005 08:54AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,142
KimSeong Loh
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,259
KimSeong Loh
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,199
Alexander Hristov
11/08/2005 03:53AM
INNER JOIN (WHERE) vs LEFT JOIN  
87,554
Veny
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,353
Sergey Petrunya
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,652
Sergey Petrunya
11/03/2005 05:18AM
Optimizer - subqueries  
4,349
Jake Day
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,366
Felix Geerinckx
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,257
Jake Day
11/02/2005 08:50AM
Does SELECT DISTINCT on an indexed column do an index scan?  
8,943
Boris Burtin
10/31/2005 03:45PM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,442
Sergey Petrunya
11/01/2005 12:56PM
Query optimizer fails terribly.  
2,999
Kostas Chatzikokolakis
10/12/2005 11:48AM
Rows Examined, why so many?  
16,175
matt roberts
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
3,823
KimSeong Loh
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
3,559
matt roberts
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
3,644
Jay Pipes
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
4,131
Jay Pipes
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
8,221
Daniel Nichter
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
5,104
matt roberts
09/21/2005 08:12AM
Optimizing ORDER BY any ideas?  
4,537
Marc Van Olmen
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,461
Jay Pipes
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,319
Marc Van Olmen
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,366
Jay Pipes
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,402
Marc Van Olmen
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,346
Marc Van Olmen
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,342
Jay Pipes
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,551
Marc Van Olmen
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
2,918
Jay Pipes
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,342
Marc Van Olmen
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,299
Jay Pipes
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,516
Jay Pipes
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
2,688
Marc Van Olmen
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,453
Jay Pipes
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,447
Marc Van Olmen
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,415
Marc Van Olmen
09/07/2005 06:28PM
2 column between optimization  
5,915
Brad Culberson
09/02/2005 12:39PM
Re: 2 column between optimization  
2,864
Jay Pipes
09/07/2005 02:48AM
Re: 2 column between optimization  
2,668
Brad Culberson
09/07/2005 12:25PM
Re: 2 column between optimization  
2,456
Jay Pipes
09/07/2005 12:54PM
Re: 2 column between optimization  
2,552
Brad Culberson
09/06/2005 09:14PM
Re: 2 column between optimization  
2,717
Jay Pipes
09/06/2005 09:22PM
Re: 2 column between optimization  
2,498
Brad Culberson
09/06/2005 11:17PM
Re: 2 column between optimization  
2,502
KimSeong Loh
09/07/2005 02:54AM
Re: 2 column between optimization  
2,554
KimSeong Loh
09/04/2005 07:21PM
Re: 2 column between optimization  
2,714
Felix Geerinckx
09/02/2005 02:01PM
Re: 2 column between optimization  
2,874
Brad Culberson
09/02/2005 02:25PM
Re: 2 column between optimization  
2,546
Jay Pipes
09/05/2005 12:03PM
Re: 2 column between optimization  
2,611
Brad Culberson
09/06/2005 09:18PM
Re: 2 column between optimization  
2,714
Felix Geerinckx
09/02/2005 03:38PM
Re: 2 column between optimization  
2,559
Brad Culberson
09/06/2005 09:17PM
Unexpected benchmark results due to query optimizer?  
3,330
Kees van den Broek
09/01/2005 07:38AM
Re: Unexpected benchmark results due to query optimizer?  
2,341
Jay Pipes
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,307
Kees van den Broek
09/07/2005 06:47AM
At Performance Limit for 2 GB RAM?  
6,973
Nick Matheson
07/20/2005 09:42AM
Re: At Performance Limit for 2 GB RAM?  
3,002
KimSeong Loh
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
2,859
Nick Matheson
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
2,849
Jay Pipes
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
2,607
Nick Matheson
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,591
Jay Pipes
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
2,625
Nick Matheson
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,545
KimSeong Loh
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,473
Nick Matheson
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
2,867
Nick Matheson
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,512
Jay Pipes
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,099
Nick Matheson
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
3,070
Jay Pipes
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,466
Nick Matheson
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,489
KimSeong Loh
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,501
Nick Matheson
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,137
Jay Pipes
07/22/2005 02:13PM
SQL syntax appears correct but EXPLAIN does not work?  
4,682
David Wynter
07/10/2005 09:25AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,275
Russell Dyer
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,533
David Wynter
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,543
Jay Pipes
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,220
Jay Pipes
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,397
David Wynter
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,248
David Wynter
07/18/2005 10:54AM
"cases for which the optimizer puts the table in the wrong order"  
2,913
mathieu
06/23/2005 07:00AM
Why does this query take 2 minutes?  
3,386
Mike Petit
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,314
KimSeong Loh
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
2,031
Mike Petit
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,181
James Day
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,132
KimSeong Loh
02/03/2005 08:34PM
Group by Query Optimization  
4,338
TiMoch TiMoch
01/03/2005 04:02AM
SELECT on multiple column index  
9,412
Andr Schršder
12/05/2004 07:18AM
Re: SELECT on multiple column index  
2,982
James Day
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,191
Andr Schršder
12/10/2004 07:51AM
Re: SELECT on multiple column index  
4,250
Sergey Petrunya
12/10/2004 08:42AM
Re: SELECT on multiple column index  
2,928
Andr Schršder
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,331
Sergey Petrunya
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,356
matthew crowley
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,293
Andr Schršder
12/09/2004 09:08AM
Issues with Sub-selects and performance on Win 2003  
3,337
Adam Reynolds
11/05/2004 07:01AM
Re: Issues with Sub-selects and performance on Win 2003  
2,246
A. Weh
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,154
Adam Reynolds
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,175
A. Weh
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,212
KimSeong Loh
11/11/2004 07:11PM
Query Optimizer Problems  
2,752
laurenty
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,305
Harrison Fisk
10/15/2004 02:11PM
Pages:
« 1
...
14 15 16 17 18

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.