MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
2,029
06/11/2006 03:39PM
13,754
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
5,904
05/24/2006 06:43PM
Re: fast way to delete records?  
4,340
06/08/2006 12:30PM
Re: fast way to delete records?  
6,422
05/24/2006 07:29AM
2,610
06/08/2006 11:27AM
27,539
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,388
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
7,799
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
8,879
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,247
11/24/2005 09:18AM
2,890
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
1,864
06/07/2006 09:47AM
8,889
05/31/2006 11:29AM
Re: Slow Database  
3,249
06/01/2006 04:14AM
Re: Slow Database  
2,455
06/01/2006 06:40PM
Re: Slow Database  
2,829
06/02/2006 02:17AM
Re: Slow Database  
2,647
06/05/2006 10:37AM
Re: Slow Database  
2,552
05/31/2006 07:43PM
Re: Slow Database  
2,506
06/01/2006 12:19AM
Re: Slow Database  
3,386
05/31/2006 12:06PM
Re: Slow Database  
2,686
05/31/2006 12:43PM
2,128
06/04/2006 09:34AM
4,592
05/29/2006 05:07AM
Re: Optimizing query with multiple joins  
2,171
05/30/2006 07:15AM
Re: Optimizing query with multiple joins  
2,296
05/29/2006 08:36AM
2,393
05/26/2006 01:06PM
Re: Great masses of files on database.  
1,449
05/26/2006 04:00PM
Re: Great masses of files on database.  
1,610
05/26/2006 08:59PM
Re: Great masses of files on database.  
1,821
05/26/2006 01:37PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
3,532
05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,276
05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,073
05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,137
05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,276
05/14/2006 06:58PM
2,278
05/18/2006 12:51AM
Re: Optimization advise needed  
1,698
05/18/2006 12:57PM
Re: Optimization advise needed  
1,689
05/18/2006 01:51AM
2,093
05/18/2006 12:00PM
Re: mySQL performance problem on subqueries  
1,730
05/15/2006 06:17PM
Re: mySQL performance problem on subqueries  
1,699
05/15/2006 12:31PM
2,200
05/13/2006 04:36AM
Re: How to optimize this query  
1,720
05/13/2006 08:22AM
Re: Problem with index and left join  
2,230
05/09/2006 06:17PM
Re: Problem with index and left join  
2,263
05/09/2006 10:44PM
Re: Problem with index and left join  
2,053
05/09/2006 11:48PM
Re: Problem with index and left join  
1,978
05/10/2006 10:52AM
Re: Optimize Query with SUM() and CASE... statements  
5,448
05/08/2006 07:57AM
2,458
05/04/2006 12:21PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,226
05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,375
05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,160
05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,661
05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY  
2,371
05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,179
05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,064
05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,054
05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,304
05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,235
05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,059
05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,378
05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,490
05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY  
5,765
05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,879
05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,421
05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,470
05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY  
5,112
05/03/2006 09:11AM
3,406
04/26/2006 01:57PM
Re: Query Optimization  
1,769
05/03/2006 03:31PM
Re: Query Optimization  
1,869
04/26/2006 04:46PM
Re: Query Optimization  
1,794
04/26/2006 04:56PM
Re: Query Optimization  
1,951
04/26/2006 05:29PM
Re: Query Optimization  
1,787
05/03/2006 03:11PM
5,676
05/02/2006 01:01PM
Re: Optimizing Substring Query  
1,833
05/02/2006 02:39PM
Re: Optimizing Substring Query  
2,418
05/02/2006 02:45PM
Re: Optimizing Substring Query  
1,623
05/02/2006 03:00PM
Re: Optimizing Substring Query  
2,256
05/02/2006 02:59PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,792
04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause  
3,967
05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause  
4,040
05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,182
05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,071
05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,832
05/02/2006 02:21PM
Re: INDEX on DATE field and MONTH() YEAR() functions  
7,681
04/30/2006 03:55PM
2,490
04/19/2006 02:11AM
Re: table design and query opimization  
1,794
04/27/2006 11:27AM
Re: table design and query opimization  
1,427
04/19/2006 10:25PM
Re: table design and query opimization  
1,797
04/19/2006 10:29AM
2,282
04/25/2006 07:41PM
Re: Optimizer not working adequately  
1,667
04/26/2006 09:43AM
Re: Optimizer not working adequately  
1,709
04/26/2006 03:36AM
Re: UNION/UNION ALL queries and parallel processing  
2,756
04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing  
2,992
04/23/2006 08:04PM
2,292
04/21/2006 04:02AM
Re: Using "optimize table"  
1,613
04/21/2006 04:26AM
Re: where condition optimization  
1,674
04/19/2006 09:51AM
Re: where condition optimization  
1,693
04/19/2006 02:26AM
2,419
04/17/2006 10:29AM
Re: Database structure question  
1,670
04/17/2006 10:54AM
3,376
04/12/2006 08:25AM
Re: High RAM usage  
2,159
04/12/2006 11:33AM
3,346
04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0  
1,716
04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0  
1,719
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
1,803
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
1,843
04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0  
1,907
04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0  
1,823
04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0  
1,752
04/10/2006 11:38AM
2,574
03/30/2006 07:44AM
Re: data design optimization  
1,924
04/01/2006 06:38AM
Re: data design optimization  
1,699
03/31/2006 04:59PM
Re: data design optimization  
1,826
03/31/2006 01:42PM
Re: data design optimization  
1,801
03/30/2006 04:03PM
Re: data design optimization  
1,865
03/30/2006 01:41PM
Query Statement  
2,276
03/30/2006 01:43PM
Re: data design optimization  
1,710
03/30/2006 09:02AM
Re: Defragmentation and Database Optimizing Tool in the Background  
1,746
03/28/2006 04:01AM
2,206
03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN  
2,165
03/27/2006 06:23PM
3,018
03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN  
1,993
03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN  
1,975
03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN  
2,034
03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN  
1,853
03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN  
1,820
03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN  
1,824
03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN  
1,825
03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN  
1,732
03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN  
2,291
03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN  
2,080
03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN  
1,893
03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN  
1,741
03/20/2006 03:34PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,134
03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,185
03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
3,763
03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,122
03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,022
03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,089
03/09/2006 02:16AM
Re: suggestion for optimizing with non-matching compound indexes  
2,061
03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes  
1,974
03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes  
2,682
03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes  
1,903
03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes  
1,883
03/24/2006 11:02AM
2,472
03/21/2006 06:10AM
Re: Query Optimization  
1,650
03/21/2006 08:24AM
Re: Query Optimization  
1,622
03/21/2006 09:19AM
Re: Query Optimization  
1,747
03/21/2006 11:24AM
2,544
01/07/2006 02:29PM
Re: Mysql high cpu usage problem  
1,949
01/31/2006 07:13AM
Re: Mysql high cpu usage problem  
2,320
03/20/2006 05:26PM
Query  
2,407
03/15/2006 11:08AM
Re: Query  
1,781
03/15/2006 11:17AM
Re: Query  
1,743
03/15/2006 11:37AM
Re: Query  
1,675
03/17/2006 08:38AM
UP , JUMP , PLEASE HELP  
1,758
03/10/2006 04:19PM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,420
03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,985
03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"  
16,195
03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,666
03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,520
03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,065
03/06/2006 08:27AM
3,689
03/01/2006 01:58PM
Re: MIN on an indexed field too slow  
2,125
03/09/2006 06:04AM
Re: MIN on an indexed field too slow  
1,839
03/02/2006 03:28PM
Re: MIN on an indexed field too slow  
1,898
03/02/2006 11:38AM
Re: MIN on an indexed field too slow  
2,016
03/01/2006 05:19PM
Re: MIN on an indexed field too slow  
1,997
03/01/2006 04:54PM
Re: MIN on an indexed field too slow  
2,098
03/01/2006 03:25PM
3,499
03/07/2006 10:17PM
Re: is HASH index being ignored  
1,941
03/08/2006 10:59AM
Re: is HASH index being ignored  
1,952
03/08/2006 04:32AM
Re: is HASH index being ignored  
1,805
03/08/2006 07:50PM
Re: Urgent Optimized QUERY needed::  
1,748
03/04/2006 04:33PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,983
02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,905
02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,838
03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,067
02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,007
02/20/2006 09:20AM
6,200
02/27/2006 01:52PM
Re: Range query performance question  
2,434
02/27/2006 02:50PM
29,224
02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')  
12,345
02/23/2006 11:12PM
Re: Need recommendation regarding IN expression  
1,973
02/22/2006 01:29PM
Re: Need recommendation regarding IN expression  
1,693
02/23/2006 12:59AM
Re: Need recommendation regarding IN expression  
2,005
02/23/2006 10:55AM
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.