MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/NET 6.10.9 has been released 07/29/2019 10:27PM
•   MySQL Connector/J 5.1.48 GA has been released 07/29/2019 01:52PM
•   MySQL Cluster 7.3.26 has been released 07/23/2019 08:40AM
•   MySQL Cluster 7.4.25 has been released 07/23/2019 01:56AM
•   MySQL Cluster 7.5.15 has been released 07/23/2019 01:40AM

Subject
Views
Written By
Posted
4,652
09/21/2006 06:56PM
Re: does MySQL support function index?  
4,671
09/21/2006 10:14PM
2,992
09/11/2006 04:37AM
Re: index choose and analyze table  
2,360
09/14/2006 08:25AM
Re: index choose and analyze table  
10,356
09/14/2006 10:38AM
Re: index choose and analyze table  
3,040
09/19/2006 04:34AM
Re: Two nearly equal querys, but very different performance  
1,659
09/12/2006 09:34AM
Re: sometimes, mysql don't use an existing index  
2,631
09/11/2006 06:29AM
Re: slow corelated subquery, not sure how to rewrite  
1,860
09/03/2006 12:00AM
Re: slow corelated subquery, not sure how to rewrite  
1,721
09/10/2006 10:18PM
Re: best way to create 'next' and 'previous' text  
1,468
09/10/2006 09:01AM
2,958
09/09/2006 01:01AM
Re: Best index for my table  
1,679
09/09/2006 02:01PM
Re: Best index for my table  
1,622
09/10/2006 12:37AM
Re: Why do mysql use temporary and filesort here?  
2,026
09/08/2006 06:36AM
2,511
08/31/2006 08:02AM
Re: slow selects  
1,737
08/31/2006 08:43AM
Re: slow selects  
1,738
08/31/2006 09:06AM
Re: slow selects  
1,738
09/01/2006 03:04AM
Re: slow selects  
1,706
09/01/2006 04:17AM
Re: slow selects  
1,917
09/01/2006 04:50AM
Re: slow selects  
1,712
09/01/2006 07:24AM
Re: slow selects  
1,727
09/01/2006 08:16AM
Re: slow selects  
1,741
09/02/2006 12:52PM
2,453
08/21/2006 11:05AM
Re: Query Optimization  
1,564
08/21/2006 06:44PM
Re: Query Optimization  
1,596
08/27/2006 11:50PM
Re: Query Optimization  
1,685
08/28/2006 07:33AM
5,853
08/23/2006 08:16PM
Re: Optimizing a UNION Query  
2,523
08/24/2006 05:28AM
Re: Optimizing a UNION Query  
2,575
08/24/2006 12:12PM
Re: Optimizing a UNION Query  
5,094
08/25/2006 06:14AM
Re: Optimizing a UNION Query  
2,517
08/24/2006 04:59AM
Re: Really need help with optimization  
1,656
08/23/2006 12:50AM
Re: Really need help with optimization  
1,758
08/23/2006 01:24PM
Re: Really need help with optimization  
1,671
08/24/2006 04:53AM
Re: Really need help with optimization  
1,650
08/22/2006 01:46PM
2,394
08/22/2006 11:30PM
Re: Left Join Problem  
1,649
08/23/2006 09:00AM
Re: Left Join Problem  
1,656
08/23/2006 06:53PM
Re: Left Join Problem  
1,600
08/23/2006 07:12PM
Re: Left Join Problem  
1,767
08/23/2006 11:01PM
2,345
07/26/2006 07:13AM
Re: optimizing the query.  
1,695
08/22/2006 12:37PM
Re: optimizing the query.  
1,702
08/04/2006 04:50AM
Re: optimizing the query.  
1,644
07/27/2006 12:13AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
1,530
08/22/2006 03:26AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
8,204
08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
3,918
08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
2,870
08/22/2006 03:25AM
Re: Force Table Selection Order in JOIN Statement?  
9,350
08/21/2006 06:24AM
Re: ORDER BY RAND() taking too much time  
3,598
06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time  
2,449
05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time  
2,940
05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time  
3,210
08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time  
2,750
05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time  
3,909
05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time  
3,354
05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time  
3,589
05/01/2006 08:49AM
Re: How to create on-the-fly index on derived table?  
6,585
08/12/2006 03:04PM
19,207
06/07/2006 10:00AM
Re: EXISTS() optimization  
6,288
07/25/2006 07:54AM
Re: EXISTS() optimization  
5,493
07/25/2006 01:13PM
Re: EXISTS() optimization  
5,035
08/04/2006 04:45AM
2,640
08/02/2006 02:02PM
Re: Too many rows being read  
1,623
08/02/2006 02:18PM
2,531
07/27/2006 12:05PM
Re: Why does this query filesort?  
1,694
08/01/2006 11:14PM
3,177
07/28/2006 03:33AM
2,268
06/23/2006 11:44AM
Re: query of tables with a longblob  
1,577
07/25/2006 01:26PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,619
07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,624
07/20/2006 10:09PM
Re: With vs Without Primary Key in a particular case  
2,679
07/20/2006 05:35PM
9,630
07/19/2006 06:11AM
3,152
07/17/2006 07:13AM
Re: LEFT JOIN problem  
1,685
07/17/2006 08:07AM
Re: LEFT JOIN problem  
1,639
07/17/2006 09:30AM
Re: LEFT JOIN problem  
1,649
07/17/2006 12:03PM
Re: LEFT JOIN problem  
1,585
07/17/2006 10:23PM
Re: (How) are subqueries optimized involving the same table?  
1,772
07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?  
1,669
07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?  
1,842
07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?  
1,672
07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?  
1,577
07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?  
1,806
07/13/2006 08:12AM
Re: How to get some documents or articles on the query optimization of MySQL????  
1,670
07/10/2006 05:12PM
5,179
07/02/2006 05:34PM
Re: min() vs limit optimization  
2,055
07/02/2006 08:26PM
Re: min() vs limit optimization  
2,013
07/03/2006 05:22PM
Re: min() vs limit optimization  
2,183
07/04/2006 06:51AM
Re: Slow Union Query Opimization. Need help.  
2,431
06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.  
2,729
06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.  
2,966
06/29/2006 08:24AM
2,657
06/27/2006 07:31AM
Re: querying time is too high  
1,764
06/29/2006 08:52AM
Re: querying time is too high  
1,700
06/29/2006 12:48AM
Re: querying time is too high  
1,802
06/28/2006 10:00AM
2,165
06/27/2006 07:17AM
Re: Joining several multi-to-multi tables  
1,891
06/23/2006 06:58AM
Re: Joining several multi-to-multi tables  
1,742
06/20/2006 12:21PM
Re: Joining several multi-to-multi tables  
1,780
06/20/2006 01:44PM
Re: Joining several multi-to-multi tables  
1,728
06/20/2006 04:23PM
Re: Joining several multi-to-multi tables  
1,703
06/20/2006 06:02PM
Re: Joining several multi-to-multi tables  
1,749
06/20/2006 01:02PM
Re: Joining several multi-to-multi tables  
1,732
06/20/2006 12:14PM
2,248
Uwe
05/22/2006 05:47AM
Re: no optimization?  
1,721
06/18/2006 08:50PM
Re: no optimization?  
1,672
Uwe
06/21/2006 10:40AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?  
1,629
06/21/2006 12:36AM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min  
1,995
06/20/2006 12:18PM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min  
2,081
06/20/2006 07:18AM
Re: Why does this delete statement take so long?  
1,920
06/15/2006 03:56PM
Re: Why does this delete statement take so long?  
1,847
06/15/2006 04:16PM
3,072
06/12/2006 06:11PM
Re: Why isn't the index being used?  
1,827
06/13/2006 04:03PM
Re: Why isn't the index being used?  
1,823
06/13/2006 09:54AM
Re: Why isn't the index being used?  
1,801
06/13/2006 10:34AM
Re: Why isn't the index being used?  
1,798
06/13/2006 09:11AM
Re: Why isn't the index being used?  
2,003
06/13/2006 08:41AM
Re: Why isn't the index being used?  
1,769
06/12/2006 06:41PM
5,606
06/13/2006 08:49AM
Re: How to avoid temporary and filesort?  
3,048
06/13/2006 09:06AM
Re: How to avoid temporary and filesort?  
3,180
06/13/2006 09:39AM
Re: How to avoid temporary and filesort?  
2,627
06/13/2006 10:31AM
12,265
06/11/2006 06:50PM
Re: How to avoid filesort  
6,012
06/12/2006 01:30PM
Re: How to avoid filesort  
6,764
06/12/2006 08:40AM
Re: How to avoid filesort  
5,995
06/12/2006 09:10AM
4,747
06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query  
2,403
06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query  
2,298
06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query  
2,306
06/12/2006 01:01PM
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
2,004
06/11/2006 03:39PM
13,702
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
5,880
05/24/2006 06:43PM
Re: fast way to delete records?  
4,323
06/08/2006 12:30PM
Re: fast way to delete records?  
6,394
05/24/2006 07:29AM
2,567
06/08/2006 11:27AM
27,478
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,353
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
7,773
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
8,864
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,228
11/24/2005 09:18AM
2,851
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
1,841
06/07/2006 09:47AM
8,846
05/31/2006 11:29AM
Re: Slow Database  
3,231
06/01/2006 04:14AM
Re: Slow Database  
2,441
06/01/2006 06:40PM
Re: Slow Database  
2,801
06/02/2006 02:17AM
Re: Slow Database  
2,627
06/05/2006 10:37AM
Re: Slow Database  
2,538
05/31/2006 07:43PM
Re: Slow Database  
2,491
06/01/2006 12:19AM
Re: Slow Database  
3,358
05/31/2006 12:06PM
Re: Slow Database  
2,664
05/31/2006 12:43PM
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.