MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.6.9 has been released 01/23/2019 12:57AM
•   MySQL Enterprise Monitor 8.0.14 has been released 01/22/2019 05:00PM
•   MySQL Cluster 7.4.23 has been released 01/22/2019 10:37AM
•   MySQL Cluster 7.5.13 has been released 01/22/2019 07:19AM
•   MySQL Cluster 7.3.24 has been released 01/22/2019 04:08AM

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

Subject
Views
Written By
Posted
Range Join Performance  
3,840
Lionel Horn
11/23/2005 08:47AM
Re: Range Join Performance  
2,062
Jay Pipes
12/26/2005 07:56PM
Re: Range Join Performance  
2,053
Igor Babaev
12/21/2005 11:10PM
does my index take effect?  
2,897
zhenxing zhai
12/21/2005 03:19AM
Re: does my index take effect?  
1,865
Igor Babaev
12/21/2005 11:03PM
Index merge optimization with joined tables?  
3,165
Kayra Otaner
12/01/2005 11:39AM
Re: Index merge optimization with joined tables?  
1,964
Igor Babaev
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,085
Brian Moon
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,120
Jay Pipes
12/07/2005 05:37PM
explain + straight join oddity  
8,519
Stuart Maclean
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,512
Igor Babaev
12/21/2005 10:44PM
Can't get my indexes right  
3,024
Tobias Ritzau
11/26/2005 04:53PM
Re: Can't get my indexes right  
1,980
Igor Babaev
12/21/2005 10:34PM
Re: Can't get my indexes right  
1,980
Tobias Ritzau
11/28/2005 02:19PM
Re: Can't get my indexes right  
1,865
Tobias Ritzau
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,098
KimSeong Loh
11/28/2005 03:17AM
Re: Can't get my indexes right  
1,925
Tobias Ritzau
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,019
KimSeong Loh
11/27/2005 07:28PM
optimization of left outer joins  
4,218
Clive Cox
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,066
Igor Babaev
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,445
Jay Pipes
12/16/2005 10:23AM
MySQL 5.0 optimizer: loose scans  
2,666
Edwin DeSouza
12/19/2005 01:46PM
Query Optimizer / SQL Translation  
3,836
Dave Wilson
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,224
Timour Katchaounov
12/14/2005 02:55AM
Group by Optimization  
6,650
Joe Genshlea
12/01/2005 08:27AM
Re: Group by Optimization  
7,246
Timour Katchaounov
12/14/2005 02:36AM
Re: Group by Optimization  
3,101
Jay Pipes
12/05/2005 11:29AM
Re: Group by Optimization  
3,635
Björn Steinbrink
12/03/2005 06:07AM
Re: Group by Optimization  
3,232
Jay Pipes
12/05/2005 11:32AM
Re: Group by Optimization  
3,119
Björn Steinbrink
12/09/2005 04:53PM
How to force the optimizer to use an index in a sub-query?  
6,402
Natalia Kuznesov
10/27/2005 10:43AM
Re: How to force the optimizer to use an index in a sub-query?  
3,360
Francisco Wong-Li
12/01/2005 01:51PM
why don't work for my substring index?  
4,057
zhenxing zhai
11/06/2005 10:09PM
Re: why don't work for my substring index?  
2,533
Francisco Wong-Li
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,410
zhenxing zhai
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,350
Felix Geerinckx
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,241
zhenxing zhai
11/09/2005 03:07AM
fast retrieval from MySQL database  
2,806
Akasmika Dash
11/21/2005 05:07AM
WHERE clause processing  
2,722
Maxx Kazimieszko
11/15/2005 05:20PM
Re: WHERE clause processing  
1,929
KimSeong Loh
11/15/2005 07:32PM
Eternal SELECT queries  
2,946
Aniceto Perez
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,035
Felix Geerinckx
11/15/2005 09:20AM
Performance of Select (pk) vs Select(*) with order by  
4,603
Alexander Hristov
11/07/2005 08:54AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,058
KimSeong Loh
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,196
KimSeong Loh
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,106
Alexander Hristov
11/08/2005 03:53AM
INNER JOIN (WHERE) vs LEFT JOIN  
87,420
Veny
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,241
Sergey Petrunya
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,588
Sergey Petrunya
11/03/2005 05:18AM
Optimizer - subqueries  
4,242
Jake Day
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,304
Felix Geerinckx
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,200
Jake Day
11/02/2005 08:50AM
Does SELECT DISTINCT on an indexed column do an index scan?  
8,844
Boris Burtin
10/31/2005 03:45PM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,378
Sergey Petrunya
11/01/2005 12:56PM
Query optimizer fails terribly.  
2,925
Kostas Chatzikokolakis
10/12/2005 11:48AM
Rows Examined, why so many?  
15,390
matt roberts
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
3,717
KimSeong Loh
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
3,450
matt roberts
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
3,538
Jay Pipes
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
3,980
Jay Pipes
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
7,949
Daniel Nichter
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
4,943
matt roberts
09/21/2005 08:12AM
Optimizing ORDER BY any ideas?  
4,436
Marc Van Olmen
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,403
Jay Pipes
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,286
Marc Van Olmen
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,314
Jay Pipes
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,333
Marc Van Olmen
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,290
Marc Van Olmen
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,278
Jay Pipes
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,490
Marc Van Olmen
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
2,863
Jay Pipes
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,292
Marc Van Olmen
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,236
Jay Pipes
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,447
Jay Pipes
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
2,637
Marc Van Olmen
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,395
Jay Pipes
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,395
Marc Van Olmen
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,348
Marc Van Olmen
09/07/2005 06:28PM
2 column between optimization  
5,812
Brad Culberson
09/02/2005 12:39PM
Re: 2 column between optimization  
2,788
Jay Pipes
09/07/2005 02:48AM
Re: 2 column between optimization  
2,604
Brad Culberson
09/07/2005 12:25PM
Re: 2 column between optimization  
2,404
Jay Pipes
09/07/2005 12:54PM
Re: 2 column between optimization  
2,491
Brad Culberson
09/06/2005 09:14PM
Re: 2 column between optimization  
2,656
Jay Pipes
09/06/2005 09:22PM
Re: 2 column between optimization  
2,437
Brad Culberson
09/06/2005 11:17PM
Re: 2 column between optimization  
2,436
KimSeong Loh
09/07/2005 02:54AM
Re: 2 column between optimization  
2,489
KimSeong Loh
09/04/2005 07:21PM
Re: 2 column between optimization  
2,659
Felix Geerinckx
09/02/2005 02:01PM
Re: 2 column between optimization  
2,783
Brad Culberson
09/02/2005 02:25PM
Re: 2 column between optimization  
2,487
Jay Pipes
09/05/2005 12:03PM
Re: 2 column between optimization  
2,547
Brad Culberson
09/06/2005 09:18PM
Re: 2 column between optimization  
2,661
Felix Geerinckx
09/02/2005 03:38PM
Re: 2 column between optimization  
2,500
Brad Culberson
09/06/2005 09:17PM
Unexpected benchmark results due to query optimizer?  
3,236
Kees van den Broek
09/01/2005 07:38AM
Re: Unexpected benchmark results due to query optimizer?  
2,276
Jay Pipes
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,253
Kees van den Broek
09/07/2005 06:47AM
At Performance Limit for 2 GB RAM?  
6,850
Nick Matheson
07/20/2005 09:42AM
Re: At Performance Limit for 2 GB RAM?  
2,925
KimSeong Loh
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
2,779
Nick Matheson
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
2,776
Jay Pipes
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
2,515
Nick Matheson
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,503
Jay Pipes
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
2,559
Nick Matheson
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,480
KimSeong Loh
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,408
Nick Matheson
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
2,800
Nick Matheson
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,440
Jay Pipes
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,045
Nick Matheson
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
2,994
Jay Pipes
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,374
Nick Matheson
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,428
KimSeong Loh
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,445
Nick Matheson
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,049
Jay Pipes
07/22/2005 02:13PM
SQL syntax appears correct but EXPLAIN does not work?  
4,582
David Wynter
07/10/2005 09:25AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,239
Russell Dyer
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,459
David Wynter
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,485
Jay Pipes
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,179
Jay Pipes
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,341
David Wynter
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,207
David Wynter
07/18/2005 10:54AM
"cases for which the optimizer puts the table in the wrong order"  
2,865
mathieu
06/23/2005 07:00AM
Why does this query take 2 minutes?  
3,278
Mike Petit
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,259
KimSeong Loh
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
1,975
Mike Petit
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,112
James Day
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,098
KimSeong Loh
02/03/2005 08:34PM
Group by Query Optimization  
4,250
TiMoch TiMoch
01/03/2005 04:02AM
SELECT on multiple column index  
9,285
Andr Schršder
12/05/2004 07:18AM
Re: SELECT on multiple column index  
2,918
James Day
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,125
Andr Schršder
12/10/2004 07:51AM
Re: SELECT on multiple column index  
2,944
Sergey Petrunya
12/10/2004 08:42AM
Re: SELECT on multiple column index  
2,849
Andr Schršder
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,265
Sergey Petrunya
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,281
matthew crowley
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,249
Andr Schršder
12/09/2004 09:08AM
Issues with Sub-selects and performance on Win 2003  
3,243
Adam Reynolds
11/05/2004 07:01AM
Re: Issues with Sub-selects and performance on Win 2003  
2,185
A. Weh
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,104
Adam Reynolds
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,144
A. Weh
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,159
KimSeong Loh
11/11/2004 07:11PM
Query Optimizer Problems  
2,684
laurenty
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,251
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.