MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.2.32 has been released 01/17/2018 12:45PM
•   MySQL Cluster 7.3.20 has been released 01/17/2018 12:36PM
•   MySQL Cluster 7.5.9 has been released 01/17/2018 12:05PM
•   MySQL Community Server 5.5.59 has been released 01/15/2018 12:30PM
•   MySQL Community Server 5.6.39 has been released 01/15/2018 11:13AM

Subject
Views
Written By
Posted
4,766
10/27/2006 09:51AM
Re: Optimizer ignores datetime index  
3,247
10/27/2006 12:48PM
Re: Optimizer ignores datetime index  
2,632
10/27/2006 01:09PM
Re: Derived tables optimized differently than when directly queried?  
1,863
10/26/2006 05:33PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,255
10/21/2006 10:55AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,630
10/22/2006 04:56AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,077
10/21/2006 11:17AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,553
10/23/2006 06:41AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,377
10/23/2006 11:02AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,055
10/23/2006 01:01PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,360
10/21/2006 05:20PM
2,414
09/15/2006 06:28AM
Re: Optimizer ignores number of records  
1,691
10/21/2006 05:05AM
2,522
10/12/2006 06:34PM
Re: Performance of two similar Selects  
1,688
10/17/2006 02:07PM
Re: How to speed up query of indexed column with 5M rows?  
4,776
10/09/2006 07:54PM
Re: How to speed up query of indexed column with 5M rows?  
6,182
10/09/2006 09:40AM
Re: How to speed up query of indexed column with 5M rows?  
5,779
10/09/2006 08:39PM
Re: How to speed up query of indexed column with 5M rows?  
8,652
10/09/2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?  
7,193
10/10/2006 12:23AM
Re: How to speed up query of indexed column with 5M rows?  
6,288
10/12/2006 07:57PM
Re: How to speed up query of indexed column with 5M rows?  
6,503
10/10/2006 08:45AM
8,241
10/06/2006 06:37AM
Re: Deactivate an activate Database  
3,007
10/06/2006 09:35AM
Re: Deactivate an activate Database  
2,687
10/06/2006 11:12PM
Re: Deactivate an activate Database  
2,515
10/06/2006 11:48PM
Re: improving speed of mysql distance filter  
3,308
06/29/2006 07:54PM
Re: improving speed of mysql distance filter  
2,942
06/28/2006 11:27AM
Re: improving speed of mysql distance filter  
3,101
06/17/2006 03:12PM
Re: improving speed of mysql distance filter  
4,315
06/28/2006 01:40AM
Re: improving speed of mysql distance filter  
5,044
10/05/2006 09:56AM
Re: improving speed of mysql distance filter  
3,163
06/17/2006 02:52PM
2,604
10/01/2006 08:56AM
Re: strange query performance  
1,723
10/01/2006 11:56AM
Re: strange query performance  
1,742
10/03/2006 02:43AM
11,578
09/13/2006 12:32AM
Re: ORDER BY doesn't use index  
3,590
09/13/2006 02:36AM
Re: ORDER BY doesn't use index  
3,269
09/27/2006 03:39AM
Re: ORDER BY doesn't use index  
3,081
09/27/2006 05:02AM
Re: ORDER BY doesn't use index  
2,995
09/30/2006 05:53PM
Re: ORDER BY doesn't use index  
2,925
10/03/2006 02:38AM
Re: ORDER BY doesn't use index  
5,079
09/13/2006 02:00AM
Re: Optimizing left outer join query  
4,427
09/25/2006 03:00AM
Re: Optimizing left outer join query  
3,863
09/25/2006 04:54AM
Re: Optimizing left outer join query  
4,061
09/25/2006 08:09AM
Re: Optimizing left outer join query  
3,384
09/25/2006 09:55PM
Re: Optimizing left outer join query  
3,291
09/26/2006 03:35AM
Re: Optimizing left outer join query  
2,783
09/26/2006 06:31PM
Re: Optimizing left outer join query  
2,941
09/26/2006 03:46AM
Re: Optimizing left outer join query  
4,650
09/26/2006 04:06AM
Re: MySQL can't find index = really slow query...  
1,610
09/25/2006 08:49AM
Re: MySQL can't find index = really slow query...  
1,655
09/25/2006 09:06AM
Re: MySQL can't find index = really slow query...  
1,938
09/25/2006 09:23AM
Re: MySQL can't find index = really slow query...  
1,765
09/25/2006 09:47AM
Re: MySQL can't find index = really slow query...  
1,555
09/25/2006 09:55AM
Re: MySQL can't find index = really slow query...  
1,653
09/25/2006 10:14AM
Re: MySQL can't find index = really slow query...  
1,772
09/25/2006 12:47PM
Re: MySQL can't find index = really slow query...  
1,532
09/26/2006 04:31AM
4,567
09/21/2006 06:56PM
Re: does MySQL support function index?  
4,605
09/21/2006 10:14PM
2,878
09/11/2006 04:37AM
Re: index choose and analyze table  
2,264
09/14/2006 08:25AM
Re: index choose and analyze table  
10,168
09/14/2006 10:38AM
Re: index choose and analyze table  
2,930
09/19/2006 04:34AM
Re: Two nearly equal querys, but very different performance  
1,527
09/12/2006 09:34AM
Re: sometimes, mysql don't use an existing index  
2,521
09/11/2006 06:29AM
Re: slow corelated subquery, not sure how to rewrite  
1,793
09/03/2006 12:00AM
Re: slow corelated subquery, not sure how to rewrite  
1,677
09/10/2006 10:18PM
Re: best way to create 'next' and 'previous' text  
1,435
09/10/2006 09:01AM
2,829
09/09/2006 01:01AM
Re: Best index for my table  
1,626
09/09/2006 02:01PM
Re: Best index for my table  
1,578
09/10/2006 12:37AM
Re: Why do mysql use temporary and filesort here?  
1,961
09/08/2006 06:36AM
2,389
08/31/2006 08:02AM
Re: slow selects  
1,683
08/31/2006 08:43AM
Re: slow selects  
1,662
08/31/2006 09:06AM
Re: slow selects  
1,662
09/01/2006 03:04AM
Re: slow selects  
1,674
09/01/2006 04:17AM
Re: slow selects  
1,833
09/01/2006 04:50AM
Re: slow selects  
1,652
09/01/2006 07:24AM
Re: slow selects  
1,602
09/01/2006 08:16AM
Re: slow selects  
1,679
09/02/2006 12:52PM
2,369
08/21/2006 11:05AM
Re: Query Optimization  
1,516
08/21/2006 06:44PM
Re: Query Optimization  
1,550
08/27/2006 11:50PM
Re: Query Optimization  
1,603
08/28/2006 07:33AM
5,672
08/23/2006 08:16PM
Re: Optimizing a UNION Query  
2,451
08/24/2006 05:28AM
Re: Optimizing a UNION Query  
2,500
08/24/2006 12:12PM
Re: Optimizing a UNION Query  
4,944
08/25/2006 06:14AM
Re: Optimizing a UNION Query  
2,434
08/24/2006 04:59AM
Re: Really need help with optimization  
1,597
08/23/2006 12:50AM
Re: Really need help with optimization  
1,654
08/23/2006 01:24PM
Re: Really need help with optimization  
1,603
08/24/2006 04:53AM
Re: Really need help with optimization  
1,597
08/22/2006 01:46PM
2,299
08/22/2006 11:30PM
Re: Left Join Problem  
1,575
08/23/2006 09:00AM
Re: Left Join Problem  
1,611
08/23/2006 06:53PM
Re: Left Join Problem  
1,567
08/23/2006 07:12PM
Re: Left Join Problem  
1,689
08/23/2006 11:01PM
2,174
07/26/2006 07:13AM
Re: optimizing the query.  
1,610
08/22/2006 12:37PM
Re: optimizing the query.  
1,658
08/04/2006 04:50AM
Re: optimizing the query.  
1,604
07/27/2006 12:13AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
1,502
08/22/2006 03:26AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
8,097
08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
3,858
08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
2,823
08/22/2006 03:25AM
Re: Force Table Selection Order in JOIN Statement?  
8,886
08/21/2006 06:24AM
Re: ORDER BY RAND() taking too much time  
3,462
06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time  
2,400
05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time  
2,850
05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time  
3,127
08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time  
2,659
05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time  
3,795
05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time  
3,269
05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time  
3,424
05/01/2006 08:49AM
Re: How to create on-the-fly index on derived table?  
6,183
08/12/2006 03:04PM
18,937
06/07/2006 10:00AM
Re: EXISTS() optimization  
6,190
07/25/2006 07:54AM
Re: EXISTS() optimization  
5,434
07/25/2006 01:13PM
Re: EXISTS() optimization  
4,953
08/04/2006 04:45AM
2,535
08/02/2006 02:02PM
Re: Too many rows being read  
1,582
08/02/2006 02:18PM
2,442
07/27/2006 12:05PM
Re: Why does this query filesort?  
1,613
08/01/2006 11:14PM
2,946
07/28/2006 03:33AM
2,197
06/23/2006 11:44AM
Re: query of tables with a longblob  
1,540
07/25/2006 01:26PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,542
07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,565
07/20/2006 10:09PM
Re: With vs Without Primary Key in a particular case  
2,602
07/20/2006 05:35PM
9,265
07/19/2006 06:11AM
2,989
07/17/2006 07:13AM
Re: LEFT JOIN problem  
1,639
07/17/2006 08:07AM
Re: LEFT JOIN problem  
1,596
07/17/2006 09:30AM
Re: LEFT JOIN problem  
1,614
07/17/2006 12:03PM
Re: LEFT JOIN problem  
1,548
07/17/2006 10:23PM
Re: (How) are subqueries optimized involving the same table?  
1,671
07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?  
1,623
07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?  
1,743
07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?  
1,631
07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?  
1,515
07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?  
1,699
07/13/2006 08:12AM
Re: How to get some documents or articles on the query optimization of MySQL????  
1,592
07/10/2006 05:12PM
4,979
07/02/2006 05:34PM
Re: min() vs limit optimization  
1,944
07/02/2006 08:26PM
Re: min() vs limit optimization  
1,931
07/03/2006 05:22PM
Re: min() vs limit optimization  
2,105
07/04/2006 06:51AM
Re: Slow Union Query Opimization. Need help.  
2,343
06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.  
2,629
06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.  
2,846
06/29/2006 08:24AM
2,541
06/27/2006 07:31AM
Re: querying time is too high  
1,658
06/29/2006 08:52AM
Re: querying time is too high  
1,627
06/29/2006 12:48AM
Re: querying time is too high  
1,720
06/28/2006 10:00AM
2,103
06/27/2006 07:17AM
Re: Joining several multi-to-multi tables  
1,832
06/23/2006 06:58AM
Re: Joining several multi-to-multi tables  
1,673
06/20/2006 12:21PM
Re: Joining several multi-to-multi tables  
1,704
06/20/2006 01:44PM
Re: Joining several multi-to-multi tables  
1,634
06/20/2006 04:23PM
Re: Joining several multi-to-multi tables  
1,627
06/20/2006 06:02PM
Re: Joining several multi-to-multi tables  
1,651
06/20/2006 01:02PM
Re: Joining several multi-to-multi tables  
1,654
06/20/2006 12:14PM
2,114
Uwe
05/22/2006 05:47AM
Re: no optimization?  
1,683
06/18/2006 08:50PM
Re: no optimization?  
1,626
Uwe
06/21/2006 10:40AM
Pages:
« 1
...
13 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.