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
2,105
06/04/2006 09:34AM
4,567
05/29/2006 05:07AM
Re: Optimizing query with multiple joins  
2,158
05/30/2006 07:15AM
Re: Optimizing query with multiple joins  
2,276
05/29/2006 08:36AM
2,371
05/26/2006 01:06PM
Re: Great masses of files on database.  
1,437
05/26/2006 04:00PM
Re: Great masses of files on database.  
1,601
05/26/2006 08:59PM
Re: Great masses of files on database.  
1,802
05/26/2006 01:37PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
3,506
05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,247
05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,046
05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,115
05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,254
05/14/2006 06:58PM
2,265
05/18/2006 12:51AM
Re: Optimization advise needed  
1,684
05/18/2006 12:57PM
Re: Optimization advise needed  
1,681
05/18/2006 01:51AM
2,075
05/18/2006 12:00PM
Re: mySQL performance problem on subqueries  
1,717
05/15/2006 06:17PM
Re: mySQL performance problem on subqueries  
1,689
05/15/2006 12:31PM
2,175
05/13/2006 04:36AM
Re: How to optimize this query  
1,708
05/13/2006 08:22AM
Re: Problem with index and left join  
2,210
05/09/2006 06:17PM
Re: Problem with index and left join  
2,249
05/09/2006 10:44PM
Re: Problem with index and left join  
2,040
05/09/2006 11:48PM
Re: Problem with index and left join  
1,957
05/10/2006 10:52AM
Re: Optimize Query with SUM() and CASE... statements  
5,379
05/08/2006 07:57AM
2,435
05/04/2006 12:21PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,192
05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,351
05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,140
05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,635
05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY  
2,344
05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,163
05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,029
05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,033
05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,272
05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,214
05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,034
05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,343
05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,466
05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY  
5,732
05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,845
05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,404
05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,445
05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY  
5,086
05/03/2006 09:11AM
3,364
04/26/2006 01:57PM
Re: Query Optimization  
1,755
05/03/2006 03:31PM
Re: Query Optimization  
1,844
04/26/2006 04:46PM
Re: Query Optimization  
1,781
04/26/2006 04:56PM
Re: Query Optimization  
1,931
04/26/2006 05:29PM
Re: Query Optimization  
1,774
05/03/2006 03:11PM
5,605
05/02/2006 01:01PM
Re: Optimizing Substring Query  
1,812
05/02/2006 02:39PM
Re: Optimizing Substring Query  
2,387
05/02/2006 02:45PM
Re: Optimizing Substring Query  
1,603
05/02/2006 03:00PM
Re: Optimizing Substring Query  
2,228
05/02/2006 02:59PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,656
04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause  
3,857
05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause  
3,936
05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,088
05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause  
3,982
05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,728
05/02/2006 02:21PM
Re: INDEX on DATE field and MONTH() YEAR() functions  
7,623
04/30/2006 03:55PM
2,454
04/19/2006 02:11AM
Re: table design and query opimization  
1,771
04/27/2006 11:27AM
Re: table design and query opimization  
1,410
04/19/2006 10:25PM
Re: table design and query opimization  
1,782
04/19/2006 10:29AM
2,260
04/25/2006 07:41PM
Re: Optimizer not working adequately  
1,652
04/26/2006 09:43AM
Re: Optimizer not working adequately  
1,692
04/26/2006 03:36AM
Re: UNION/UNION ALL queries and parallel processing  
2,728
04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing  
2,945
04/23/2006 08:04PM
2,261
04/21/2006 04:02AM
Re: Using "optimize table"  
1,600
04/21/2006 04:26AM
Re: where condition optimization  
1,662
04/19/2006 09:51AM
Re: where condition optimization  
1,680
04/19/2006 02:26AM
2,392
04/17/2006 10:29AM
Re: Database structure question  
1,653
04/17/2006 10:54AM
3,350
04/12/2006 08:25AM
Re: High RAM usage  
2,144
04/12/2006 11:33AM
3,296
04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0  
1,698
04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0  
1,702
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
1,788
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
1,817
04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0  
1,887
04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0  
1,807
04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0  
1,736
04/10/2006 11:38AM
2,549
03/30/2006 07:44AM
Re: data design optimization  
1,903
04/01/2006 06:38AM
Re: data design optimization  
1,687
03/31/2006 04:59PM
Re: data design optimization  
1,816
03/31/2006 01:42PM
Re: data design optimization  
1,782
03/30/2006 04:03PM
Re: data design optimization  
1,845
03/30/2006 01:41PM
Query Statement  
2,242
03/30/2006 01:43PM
Re: data design optimization  
1,698
03/30/2006 09:02AM
Re: Defragmentation and Database Optimizing Tool in the Background  
1,734
03/28/2006 04:01AM
2,184
03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN  
2,149
03/27/2006 06:23PM
2,992
03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN  
1,973
03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN  
1,954
03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN  
2,010
03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN  
1,833
03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN  
1,806
03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN  
1,801
03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN  
1,809
03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN  
1,711
03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN  
2,260
03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN  
2,060
03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN  
1,880
03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN  
1,725
03/20/2006 03:34PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,118
03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,165
03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
3,745
03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,100
03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
1,998
03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,073
03/09/2006 02:16AM
Re: suggestion for optimizing with non-matching compound indexes  
2,034
03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes  
1,955
03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes  
2,652
03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes  
1,887
03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes  
1,868
03/24/2006 11:02AM
2,453
03/21/2006 06:10AM
Re: Query Optimization  
1,638
03/21/2006 08:24AM
Re: Query Optimization  
1,610
03/21/2006 09:19AM
Re: Query Optimization  
1,735
03/21/2006 11:24AM
2,524
01/07/2006 02:29PM
Re: Mysql high cpu usage problem  
1,937
01/31/2006 07:13AM
Re: Mysql high cpu usage problem  
2,308
03/20/2006 05:26PM
Query  
2,384
03/15/2006 11:08AM
Re: Query  
1,767
03/15/2006 11:17AM
Re: Query  
1,728
03/15/2006 11:37AM
Re: Query  
1,663
03/17/2006 08:38AM
UP , JUMP , PLEASE HELP  
1,743
03/10/2006 04:19PM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,389
03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,941
03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"  
16,161
03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,616
03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,480
03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,035
03/06/2006 08:27AM
3,620
03/01/2006 01:58PM
Re: MIN on an indexed field too slow  
2,109
03/09/2006 06:04AM
Re: MIN on an indexed field too slow  
1,823
03/02/2006 03:28PM
Re: MIN on an indexed field too slow  
1,881
03/02/2006 11:38AM
Re: MIN on an indexed field too slow  
2,000
03/01/2006 05:19PM
Re: MIN on an indexed field too slow  
1,976
03/01/2006 04:54PM
Re: MIN on an indexed field too slow  
2,075
03/01/2006 03:25PM
3,457
03/07/2006 10:17PM
Re: is HASH index being ignored  
1,915
03/08/2006 10:59AM
Re: is HASH index being ignored  
1,939
03/08/2006 04:32AM
Re: is HASH index being ignored  
1,791
03/08/2006 07:50PM
Re: Urgent Optimized QUERY needed::  
1,736
03/04/2006 04:33PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,961
02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,881
02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,818
03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,033
02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,989
02/20/2006 09:20AM
6,157
02/27/2006 01:52PM
Re: Range query performance question  
2,417
02/27/2006 02:50PM
29,171
02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')  
12,317
02/23/2006 11:12PM
Re: Need recommendation regarding IN expression  
1,953
02/22/2006 01:29PM
Re: Need recommendation regarding IN expression  
1,676
02/23/2006 12:59AM
Re: Need recommendation regarding IN expression  
1,984
02/23/2006 10:55AM
5,992
12/01/2005 03:33AM
Re: slow subquery  
5,000
02/23/2006 08:04AM
Re: slow subquery  
2,414
02/22/2006 01:06PM
Re: slow subquery  
2,416
12/19/2005 11:58PM
Re: slow subquery  
2,811
12/30/2005 12:43PM
Re: slow subquery (query is fast)  
3,145
12/30/2005 02:25PM
Re: slow subquery  
2,485
12/09/2005 02:32PM
Re: slow subquery  
2,643
12/07/2005 08:18AM
Re: possible_keys exist but key is NULL  
3,796
02/22/2006 02:12PM
3,456
02/19/2006 11:45AM
2,000
02/17/2006 01:37PM
Re: Subquery performance improvements: When?  
2,272
02/14/2006 08:31AM
Re: Subquery performance improvements: When?  
2,267
02/09/2006 10:43AM
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.