MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/C 6.1.11 GA has been released 07/24/2017 10:19AM
•   MySQL Router 2.1.4 GA has been released 07/24/2017 09:15AM
•   MySQL Connector/ODBC 5.3.9 has been released 07/24/2017 08:59AM
•   MySQL Connector/J 5.1.43 has been released 07/21/2017 02:07PM
•   MySQL Cluster 7.5.7 has been released 07/19/2017 04:43AM

Subject
Views
Written By
Posted
4,547
09/21/2006 06:56PM
Re: does MySQL support function index?  
4,587
09/21/2006 10:14PM
2,852
09/11/2006 04:37AM
Re: index choose and analyze table  
2,243
09/14/2006 08:25AM
Re: index choose and analyze table  
10,110
09/14/2006 10:38AM
Re: index choose and analyze table  
2,903
09/19/2006 04:34AM
Re: Two nearly equal querys, but very different performance  
1,506
09/12/2006 09:34AM
Re: sometimes, mysql don't use an existing index  
2,487
09/11/2006 06:29AM
Re: slow corelated subquery, not sure how to rewrite  
1,763
09/03/2006 12:00AM
Re: slow corelated subquery, not sure how to rewrite  
1,661
09/10/2006 10:18PM
Re: best way to create 'next' and 'previous' text  
1,419
09/10/2006 09:01AM
2,808
09/09/2006 01:01AM
Re: Best index for my table  
1,611
09/09/2006 02:01PM
Re: Best index for my table  
1,563
09/10/2006 12:37AM
Re: Why do mysql use temporary and filesort here?  
1,932
09/08/2006 06:36AM
2,358
08/31/2006 08:02AM
Re: slow selects  
1,662
08/31/2006 08:43AM
Re: slow selects  
1,642
08/31/2006 09:06AM
Re: slow selects  
1,644
09/01/2006 03:04AM
Re: slow selects  
1,660
09/01/2006 04:17AM
Re: slow selects  
1,811
09/01/2006 04:50AM
Re: slow selects  
1,627
09/01/2006 07:24AM
Re: slow selects  
1,582
09/01/2006 08:16AM
Re: slow selects  
1,659
09/02/2006 12:52PM
2,347
08/21/2006 11:05AM
Re: Query Optimization  
1,503
08/21/2006 06:44PM
Re: Query Optimization  
1,536
08/27/2006 11:50PM
Re: Query Optimization  
1,581
08/28/2006 07:33AM
5,636
08/23/2006 08:16PM
Re: Optimizing a UNION Query  
2,427
08/24/2006 05:28AM
Re: Optimizing a UNION Query  
2,478
08/24/2006 12:12PM
Re: Optimizing a UNION Query  
4,915
08/25/2006 06:14AM
Re: Optimizing a UNION Query  
2,415
08/24/2006 04:59AM
Re: Really need help with optimization  
1,574
08/23/2006 12:50AM
Re: Really need help with optimization  
1,635
08/23/2006 01:24PM
Re: Really need help with optimization  
1,584
08/24/2006 04:53AM
Re: Really need help with optimization  
1,583
08/22/2006 01:46PM
2,278
08/22/2006 11:30PM
Re: Left Join Problem  
1,555
08/23/2006 09:00AM
Re: Left Join Problem  
1,594
08/23/2006 06:53PM
Re: Left Join Problem  
1,555
08/23/2006 07:12PM
Re: Left Join Problem  
1,669
08/23/2006 11:01PM
2,147
07/26/2006 07:13AM
Re: optimizing the query.  
1,593
08/22/2006 12:37PM
Re: optimizing the query.  
1,641
08/04/2006 04:50AM
Re: optimizing the query.  
1,591
07/27/2006 12:13AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
1,489
08/22/2006 03:26AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
8,065
08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
3,837
08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
2,808
08/22/2006 03:25AM
Re: Force Table Selection Order in JOIN Statement?  
8,732
08/21/2006 06:24AM
Re: ORDER BY RAND() taking too much time  
3,431
06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time  
2,384
05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time  
2,823
05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time  
3,095
08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time  
2,628
05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time  
3,764
05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time  
3,243
05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time  
3,389
05/01/2006 08:49AM
Re: How to create on-the-fly index on derived table?  
5,747
08/12/2006 03:04PM
18,855
06/07/2006 10:00AM
Re: EXISTS() optimization  
6,159
07/25/2006 07:54AM
Re: EXISTS() optimization  
5,418
07/25/2006 01:13PM
Re: EXISTS() optimization  
4,928
08/04/2006 04:45AM
2,510
08/02/2006 02:02PM
Re: Too many rows being read  
1,569
08/02/2006 02:18PM
2,417
07/27/2006 12:05PM
Re: Why does this query filesort?  
1,594
08/01/2006 11:14PM
2,897
07/28/2006 03:33AM
2,176
06/23/2006 11:44AM
Re: query of tables with a longblob  
1,526
07/25/2006 01:26PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,524
07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,549
07/20/2006 10:09PM
Re: With vs Without Primary Key in a particular case  
2,585
07/20/2006 05:35PM
9,156
07/19/2006 06:11AM
2,938
07/17/2006 07:13AM
Re: LEFT JOIN problem  
1,619
07/17/2006 08:07AM
Re: LEFT JOIN problem  
1,581
07/17/2006 09:30AM
Re: LEFT JOIN problem  
1,597
07/17/2006 12:03PM
Re: LEFT JOIN problem  
1,534
07/17/2006 10:23PM
Re: (How) are subqueries optimized involving the same table?  
1,646
07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?  
1,610
07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?  
1,719
07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?  
1,614
07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?  
1,499
07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?  
1,670
07/13/2006 08:12AM
Re: How to get some documents or articles on the query optimization of MySQL????  
1,575
07/10/2006 05:12PM
4,942
07/02/2006 05:34PM
Re: min() vs limit optimization  
1,922
07/02/2006 08:26PM
Re: min() vs limit optimization  
1,907
07/03/2006 05:22PM
Re: min() vs limit optimization  
2,086
07/04/2006 06:51AM
Re: Slow Union Query Opimization. Need help.  
2,321
06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.  
2,597
06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.  
2,818
06/29/2006 08:24AM
2,512
06/27/2006 07:31AM
Re: querying time is too high  
1,632
06/29/2006 08:52AM
Re: querying time is too high  
1,608
06/29/2006 12:48AM
Re: querying time is too high  
1,694
06/28/2006 10:00AM
2,078
06/27/2006 07:17AM
Re: Joining several multi-to-multi tables  
1,816
06/23/2006 06:58AM
Re: Joining several multi-to-multi tables  
1,655
06/20/2006 12:21PM
Re: Joining several multi-to-multi tables  
1,686
06/20/2006 01:44PM
Re: Joining several multi-to-multi tables  
1,613
06/20/2006 04:23PM
Re: Joining several multi-to-multi tables  
1,608
06/20/2006 06:02PM
Re: Joining several multi-to-multi tables  
1,625
06/20/2006 01:02PM
Re: Joining several multi-to-multi tables  
1,637
06/20/2006 12:14PM
2,091
Uwe
05/22/2006 05:47AM
Re: no optimization?  
1,667
06/18/2006 08:50PM
Re: no optimization?  
1,603
Uwe
06/21/2006 10:40AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?  
1,576
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,855
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  
1,909
06/20/2006 07:18AM
Re: Why does this delete statement take so long?  
1,824
06/15/2006 03:56PM
Re: Why does this delete statement take so long?  
1,726
06/15/2006 04:16PM
2,939
06/12/2006 06:11PM
Re: Why isn't the index being used?  
1,701
06/13/2006 04:03PM
Re: Why isn't the index being used?  
1,758
06/13/2006 09:54AM
Re: Why isn't the index being used?  
1,745
06/13/2006 10:34AM
Re: Why isn't the index being used?  
1,725
06/13/2006 09:11AM
Re: Why isn't the index being used?  
1,857
06/13/2006 08:41AM
Re: Why isn't the index being used?  
1,708
06/12/2006 06:41PM
5,311
06/13/2006 08:49AM
Re: How to avoid temporary and filesort?  
2,975
06/13/2006 09:06AM
Re: How to avoid temporary and filesort?  
3,041
06/13/2006 09:39AM
Re: How to avoid temporary and filesort?  
2,542
06/13/2006 10:31AM
12,105
06/11/2006 06:50PM
Re: How to avoid filesort  
5,880
06/12/2006 01:30PM
Re: How to avoid filesort  
6,684
06/12/2006 08:40AM
Re: How to avoid filesort  
5,870
06/12/2006 09:10AM
4,570
06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query  
2,283
06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query  
2,183
06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query  
2,168
06/12/2006 01:01PM
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
1,929
06/11/2006 03:39PM
13,280
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
5,677
05/24/2006 06:43PM
Re: fast way to delete records?  
4,234
06/08/2006 12:30PM
Re: fast way to delete records?  
6,190
05/24/2006 07:29AM
2,397
06/08/2006 11:27AM
26,962
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,192
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
6,787
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
8,739
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,141
11/24/2005 09:18AM
2,648
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
1,736
06/07/2006 09:47AM
8,645
05/31/2006 11:29AM
Re: Slow Database  
3,053
06/01/2006 04:14AM
Re: Slow Database  
2,353
06/01/2006 06:40PM
Re: Slow Database  
2,635
06/02/2006 02:17AM
Re: Slow Database  
2,521
06/05/2006 10:37AM
Re: Slow Database  
2,441
05/31/2006 07:43PM
Re: Slow Database  
2,412
06/01/2006 12:19AM
Re: Slow Database  
3,233
05/31/2006 12:06PM
Re: Slow Database  
2,552
05/31/2006 12:43PM
Pages:
« 1
...
13 14 15 16 17 »

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.