MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/J 5.1.49 GA has been released 04/29/2020 08:57AM
•   MySQL Cluster 7.3.29 has been released 04/29/2020 01:52AM
•   MySQL Cluster 7.5.18 has been released 04/28/2020 11:09AM
•   MySQL Cluster 7.6.14 has been released 04/28/2020 06:31AM
•   MySQL Cluster 7.4.28 has been released 04/28/2020 04:08AM

Subject
Views
Written By
Posted
Re: suggestion for optimizing with non-matching compound indexes  
2,080
03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes  
1,995
03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes  
2,705
03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes  
1,918
03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes  
1,897
03/24/2006 11:02AM
2,497
03/21/2006 06:10AM
Re: Query Optimization  
1,662
03/21/2006 08:24AM
Re: Query Optimization  
1,636
03/21/2006 09:19AM
Re: Query Optimization  
1,761
03/21/2006 11:24AM
2,565
01/07/2006 02:29PM
Re: Mysql high cpu usage problem  
1,962
01/31/2006 07:13AM
Re: Mysql high cpu usage problem  
2,333
03/20/2006 05:26PM
Query  
2,431
03/15/2006 11:08AM
Re: Query  
1,792
03/15/2006 11:17AM
Re: Query  
1,759
03/15/2006 11:37AM
Re: Query  
1,688
03/17/2006 08:38AM
UP , JUMP , PLEASE HELP  
1,772
03/10/2006 04:19PM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,461
03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,019
03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"  
16,227
03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,714
03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,565
03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,104
03/06/2006 08:27AM
3,759
03/01/2006 01:58PM
Re: MIN on an indexed field too slow  
2,140
03/09/2006 06:04AM
Re: MIN on an indexed field too slow  
1,854
03/02/2006 03:28PM
Re: MIN on an indexed field too slow  
1,914
03/02/2006 11:38AM
Re: MIN on an indexed field too slow  
2,031
03/01/2006 05:19PM
Re: MIN on an indexed field too slow  
2,015
03/01/2006 04:54PM
Re: MIN on an indexed field too slow  
2,134
03/01/2006 03:25PM
3,522
03/07/2006 10:17PM
Re: is HASH index being ignored  
1,968
03/08/2006 10:59AM
Re: is HASH index being ignored  
1,966
03/08/2006 04:32AM
Re: is HASH index being ignored  
1,819
03/08/2006 07:50PM
Re: Urgent Optimized QUERY needed::  
1,764
03/04/2006 04:33PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,996
02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,925
02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,854
03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,093
02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,021
02/20/2006 09:20AM
6,234
02/27/2006 01:52PM
Re: Range query performance question  
2,454
02/27/2006 02:50PM
29,282
02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')  
12,376
02/23/2006 11:12PM
Re: Need recommendation regarding IN expression  
1,988
02/22/2006 01:29PM
Re: Need recommendation regarding IN expression  
1,722
02/23/2006 12:59AM
Re: Need recommendation regarding IN expression  
2,029
02/23/2006 10:55AM
6,096
12/01/2005 03:33AM
Re: slow subquery  
5,038
02/23/2006 08:04AM
Re: slow subquery  
2,449
02/22/2006 01:06PM
Re: slow subquery  
2,447
12/19/2005 11:58PM
Re: slow subquery  
2,888
12/30/2005 12:43PM
Re: slow subquery (query is fast)  
3,195
12/30/2005 02:25PM
Re: slow subquery  
2,530
12/09/2005 02:32PM
Re: slow subquery  
2,703
12/07/2005 08:18AM
Re: possible_keys exist but key is NULL  
3,965
02/22/2006 02:12PM
3,525
02/19/2006 11:45AM
2,053
02/17/2006 01:37PM
Re: Subquery performance improvements: When?  
2,309
02/14/2006 08:31AM
Re: Subquery performance improvements: When?  
2,292
02/09/2006 10:43AM
3,058
02/07/2006 04:21PM
Re: SUBQUERY PROBLEM  
1,937
02/13/2006 12:16PM
Re: SUBQUERY PROBLEM  
2,119
02/13/2006 11:17AM
Re: SUBQUERY PROBLEM  
2,019
02/13/2006 11:22AM
Re: SUBQUERY PROBLEM  
2,180
02/13/2006 11:06AM
Re: SUBQUERY PROBLEM  
2,002
02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team  
2,004
02/08/2006 10:26AM
Re: SUBQUERY PROBLEM  
2,066
02/08/2006 04:57AM
Re: SUBQUERY PROBLEM  
1,933
02/08/2006 03:59PM
Re: SUBQUERY PROBLEM  
2,062
02/07/2006 04:45PM
Re: SUBQUERY PROBLEM  
1,965
02/07/2006 04:52PM
5,083
02/06/2006 11:08AM
Re: Subqueries too slow  
2,105
02/10/2006 09:49AM
Re: Subqueries too slow  
2,271
02/10/2006 10:43AM
Re: Subqueries too slow  
2,397
02/10/2006 03:18AM
Re: Subqueries too slow  
2,043
02/10/2006 08:51AM
Re: Subqueries too slow  
2,361
02/07/2006 08:38AM
Re: Subqueries too slow  
2,367
02/06/2006 02:17PM
Re: Subqueries too slow  
2,347
02/07/2006 07:06AM
Re: Subqueries too slow  
2,569
02/06/2006 11:54AM
2,271
02/09/2006 09:44PM
3,060
02/09/2006 09:42AM
Re: clash between unique and index keys  
2,323
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,589
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,343
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,513
02/08/2006 05:49PM
7,985
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,725
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,070
02/07/2006 12:13PM
2,902
01/17/2006 02:41PM
Re: optimize  
1,907
02/02/2006 09:02AM
Re: optimize  
1,943
01/18/2006 09:07AM
Re: optimize  
1,923
01/17/2006 06:48PM
7,921
01/12/2006 02:21PM
Re: Double Index Performance  
2,681
01/16/2006 06:24AM
Re: Double Index Performance  
2,737
01/16/2006 08:46AM
Re: Double Index Performance  
2,360
01/17/2006 06:45AM
Re: Double Index Performance  
2,582
02/01/2006 01:05PM
Re: Double Index Performance  
3,060
01/13/2006 05:18PM
Re: 'where' with 'in' doesn't use index?  
2,057
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
1,947
01/30/2006 04:45PM
2,622
01/20/2006 06:51AM
Re: subquery breaks optimization  
1,909
01/24/2006 07:14PM
2,644
01/12/2006 08:22AM
Re: mysql dont use my Index?  
1,886
01/18/2006 10:36PM
Re: does Select values effect index selection?  
1,879
01/10/2006 05:04PM
2,695
01/03/2006 02:28PM
Re: Optimizing with DATE()  
1,913
01/03/2006 06:53PM
3,012
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,080
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
1,999
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,069
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
1,953
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
2,052
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
2,000
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
2,059
11/01/2005 08:03AM
Re: select distinct slower in 5.0 than 4.1  
2,096
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,061
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,110
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,164
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,439
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,179
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,113
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,117
12/21/2005 01:54AM
3,971
11/23/2005 08:47AM
Re: Range Join Performance  
2,159
12/26/2005 07:56PM
Re: Range Join Performance  
2,120
12/21/2005 11:10PM
3,059
12/21/2005 03:19AM
Re: does my index take effect?  
1,929
12/21/2005 11:03PM
Re: Index merge optimization with joined tables?  
2,024
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,161
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,174
12/07/2005 05:37PM
8,636
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,571
12/21/2005 10:44PM
3,149
11/26/2005 04:53PM
Re: Can't get my indexes right  
2,029
12/21/2005 10:34PM
Re: Can't get my indexes right  
2,036
11/28/2005 02:19PM
Re: Can't get my indexes right  
1,921
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,165
11/28/2005 03:17AM
Re: Can't get my indexes right  
1,976
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,112
11/27/2005 07:28PM
4,376
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,124
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,568
12/16/2005 10:23AM
2,756
12/19/2005 01:46PM
3,966
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,291
12/14/2005 02:55AM
6,841
12/01/2005 08:27AM
Re: Group by Optimization  
7,395
12/14/2005 02:36AM
Re: Group by Optimization  
3,165
12/05/2005 11:29AM
Re: Group by Optimization  
3,723
12/03/2005 06:07AM
Re: Group by Optimization  
3,363
12/05/2005 11:32AM
Re: Group by Optimization  
3,214
12/09/2005 04:53PM
Re: How to force the optimizer to use an index in a sub-query?  
3,446
12/01/2005 01:51PM
Re: why don't work for my substring index?  
2,620
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,496
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,478
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,305
11/09/2005 03:07AM
2,813
11/15/2005 05:20PM
Re: WHERE clause processing  
1,988
11/15/2005 07:32PM
3,113
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,130
11/15/2005 09:20AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,196
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,304
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,258
11/08/2005 03:53AM
Pages:
« 1
...
15 16 17 18 19 »

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.