MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/ODBC 5.3.13 has been released 04/29/2019 05:44PM
•   MySQL Cluster 7.6.10 has been released 04/27/2019 03:25AM
•   MySQL Cluster 7.5.14 has been released 04/26/2019 12:12PM
•   MySQL Cluster 7.3.25 has been released 04/26/2019 11:34AM
•   MySQL Cluster 7.4.24 has been released 04/26/2019 11:00AM

Subject
Views
Written By
Posted
Re: clash between unique and index keys  
2,277
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,501
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,306
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,436
02/08/2006 05:49PM
7,891
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,643
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,009
02/07/2006 12:13PM
2,788
01/17/2006 02:41PM
Re: optimize  
1,856
02/02/2006 09:02AM
Re: optimize  
1,887
01/18/2006 09:07AM
Re: optimize  
1,873
01/17/2006 06:48PM
7,808
01/12/2006 02:21PM
Re: Double Index Performance  
2,593
01/16/2006 06:24AM
Re: Double Index Performance  
2,656
01/16/2006 08:46AM
Re: Double Index Performance  
2,318
01/17/2006 06:45AM
Re: Double Index Performance  
2,501
02/01/2006 01:05PM
Re: Double Index Performance  
3,011
01/13/2006 05:18PM
Re: 'where' with 'in' doesn't use index?  
1,992
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
1,898
01/30/2006 04:45PM
2,536
01/20/2006 06:51AM
Re: subquery breaks optimization  
1,861
01/24/2006 07:14PM
2,563
01/12/2006 08:22AM
Re: mysql dont use my Index?  
1,848
01/18/2006 10:36PM
Re: does Select values effect index selection?  
1,843
01/10/2006 05:04PM
2,611
01/03/2006 02:28PM
Re: Optimizing with DATE()  
1,862
01/03/2006 06:53PM
2,911
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,025
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
1,947
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,012
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
1,903
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
1,980
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
1,916
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
1,986
11/01/2005 08:03AM
Re: select distinct slower in 5.0 than 4.1  
2,039
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,007
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,068
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,081
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,354
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,119
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,045
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,044
12/21/2005 01:54AM
3,861
11/23/2005 08:47AM
Re: Range Join Performance  
2,082
12/26/2005 07:56PM
Re: Range Join Performance  
2,072
12/21/2005 11:10PM
2,937
12/21/2005 03:19AM
Re: does my index take effect?  
1,874
12/21/2005 11:03PM
Re: Index merge optimization with joined tables?  
1,970
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,107
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,126
12/07/2005 05:37PM
8,552
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,519
12/21/2005 10:44PM
3,044
11/26/2005 04:53PM
Re: Can't get my indexes right  
1,988
12/21/2005 10:34PM
Re: Can't get my indexes right  
1,990
11/28/2005 02:19PM
Re: Can't get my indexes right  
1,873
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,117
11/28/2005 03:17AM
Re: Can't get my indexes right  
1,932
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,038
11/27/2005 07:28PM
4,253
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,083
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,470
12/16/2005 10:23AM
2,680
12/19/2005 01:46PM
3,858
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,233
12/14/2005 02:55AM
6,696
12/01/2005 08:27AM
Re: Group by Optimization  
7,284
12/14/2005 02:36AM
Re: Group by Optimization  
3,115
12/05/2005 11:29AM
Re: Group by Optimization  
3,651
12/03/2005 06:07AM
Re: Group by Optimization  
3,262
12/05/2005 11:32AM
Re: Group by Optimization  
3,147
12/09/2005 04:53PM
Re: How to force the optimizer to use an index in a sub-query?  
3,393
12/01/2005 01:51PM
Re: why don't work for my substring index?  
2,552
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,432
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,387
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,252
11/09/2005 03:07AM
2,741
11/15/2005 05:20PM
Re: WHERE clause processing  
1,938
11/15/2005 07:32PM
2,990
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,049
11/15/2005 09:20AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,097
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,220
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,148
11/08/2005 03:53AM
87,484
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,292
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,616
11/03/2005 05:18AM
4,287
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,329
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,220
11/02/2005 08:50AM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,400
11/01/2005 12:56PM
15,750
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
3,763
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
3,501
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
3,583
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
4,046
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
8,070
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
5,014
09/21/2005 08:12AM
4,478
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,428
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,294
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,332
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,354
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,309
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,306
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,510
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
2,886
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,310
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,257
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,474
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
2,654
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,414
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,417
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,373
09/07/2005 06:28PM
5,861
09/02/2005 12:39PM
Re: 2 column between optimization  
2,824
09/07/2005 02:48AM
Re: 2 column between optimization  
2,629
09/07/2005 12:25PM
Re: 2 column between optimization  
2,427
09/07/2005 12:54PM
Re: 2 column between optimization  
2,515
09/06/2005 09:14PM
Re: 2 column between optimization  
2,679
09/06/2005 09:22PM
Re: 2 column between optimization  
2,466
09/06/2005 11:17PM
Re: 2 column between optimization  
2,469
09/07/2005 02:54AM
Re: 2 column between optimization  
2,518
09/04/2005 07:21PM
Re: 2 column between optimization  
2,683
09/02/2005 02:01PM
Re: 2 column between optimization  
2,815
09/02/2005 02:25PM
Re: 2 column between optimization  
2,508
09/05/2005 12:03PM
Re: 2 column between optimization  
2,571
09/06/2005 09:18PM
Re: 2 column between optimization  
2,685
09/02/2005 03:38PM
Re: 2 column between optimization  
2,524
09/06/2005 09:17PM
Re: Unexpected benchmark results due to query optimizer?  
2,302
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,271
09/07/2005 06:47AM
Re: At Performance Limit for 2 GB RAM?  
2,963
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
2,814
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
2,811
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
2,551
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,542
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
2,585
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,508
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,436
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
2,827
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,470
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,066
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
3,025
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,416
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,451
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,467
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,090
07/22/2005 02:13PM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,250
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,486
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,509
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,194
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,366
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,219
07/18/2005 10:54AM
3,315
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,277
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
1,991
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,137
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,109
02/03/2005 08:34PM
4,282
01/03/2005 04:02AM
Re: SELECT on multiple column index  
2,948
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,153
12/10/2004 07:51AM
Re: SELECT on multiple column index  
4,204
12/10/2004 08:42AM
Re: SELECT on multiple column index  
2,881
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,293
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,316
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,268
12/09/2004 09:08AM
Re: Issues with Sub-selects and performance on Win 2003  
2,206
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,122
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,151
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,181
11/11/2004 07:11PM
2,708
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,263
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.