MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic
Pages:
« 1
...
15 16 17 18 19 »

Subject
Views
Written By
Posted
Why is FULLTEXT index not used with a LEFT JOIN?  
3,771
Tad Woods
06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
2,029
Tad Woods
06/11/2006 03:39PM
fast way to delete records?  
13,754
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
5,904
KimSeong Loh
05/24/2006 06:43PM
Re: fast way to delete records?  
4,340
tri.truong
06/08/2006 12:30PM
Re: fast way to delete records?  
6,422
Anthony Willard
05/24/2006 07:29AM
Will sort help optimizing this query?  
2,610
binglew
06/08/2006 11:27AM
count(*) versus mysql_num_rows  
27,539
nachomonterde
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,388
Rob Blick
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
7,799
Paul Loy
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
8,879
Alexandru Cristescu
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,247
Jacky Shu
11/24/2005 09:18AM
Selecting a proper table stucture  
2,890
Daniel Misio
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
1,864
Anthony Willard
06/07/2006 09:47AM
Slow Database  
8,889
Dominic Hayhoe
05/31/2006 11:29AM
Re: Slow Database  
3,249
Dominic Hayhoe
06/01/2006 04:14AM
Re: Slow Database  
2,455
KimSeong Loh
06/01/2006 06:40PM
Re: Slow Database  
2,829
Dominic Hayhoe
06/02/2006 02:17AM
Re: Slow Database  
2,647
KimSeong Loh
06/05/2006 10:37AM
Re: Slow Database  
2,552
KimSeong Loh
05/31/2006 07:43PM
Re: Slow Database  
2,506
Dominic Hayhoe
06/01/2006 12:19AM
Re: Slow Database  
3,386
Peter Brawley
05/31/2006 12:06PM
Re: Slow Database  
2,686
Dominic Hayhoe
05/31/2006 12:43PM
Help to optimize my query  
2,128
björn spiegel
06/04/2006 09:34AM
Optimizing query with multiple joins  
4,592
EM Ayllon
05/29/2006 05:07AM
Re: Optimizing query with multiple joins  
2,171
EM Ayllon
05/30/2006 07:15AM
Re: Optimizing query with multiple joins  
2,296
Peter Brawley
05/29/2006 08:36AM
Great masses of files on database.  
2,393
Tronks
05/26/2006 01:06PM
Re: Great masses of files on database.  
1,449
Bill Karwin
05/26/2006 04:00PM
Re: Great masses of files on database.  
1,610
Peter Brawley
05/26/2006 08:59PM
Re: Great masses of files on database.  
1,821
Anthony Willard
05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY  
6,282
Jerome Asselin
05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
3,532
Jerome Asselin
05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,276
Jerome Asselin
05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,073
KimSeong Loh
05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,137
Jerome Asselin
05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,276
KimSeong Loh
05/14/2006 06:58PM
Optimization advise needed  
2,278
Jerry Tian
05/18/2006 12:51AM
Re: Optimization advise needed  
1,698
Jerry Tian
05/18/2006 12:57PM
Re: Optimization advise needed  
1,689
Björn Steinbrink
05/18/2006 01:51AM
index ignored  
2,093
Lauren Bradford
05/18/2006 12:00PM
mySQL performance problem on subqueries  
2,452
Falcon Meriva
05/15/2006 05:14AM
Re: mySQL performance problem on subqueries  
1,730
KimSeong Loh
05/15/2006 06:17PM
Re: mySQL performance problem on subqueries  
1,699
Peter Brawley
05/15/2006 12:31PM
How to optimize this query  
2,200
Yogesh Salvi
05/13/2006 04:36AM
Re: How to optimize this query  
1,720
Apachez
05/13/2006 08:22AM
Problem with index and left join  
3,955
Erland Isaksson
05/05/2006 03:04PM
Re: Problem with index and left join  
2,230
KimSeong Loh
05/09/2006 06:17PM
Re: Problem with index and left join  
2,263
Erland Isaksson
05/09/2006 10:44PM
Re: Problem with index and left join  
2,053
Apachez
05/09/2006 11:48PM
Re: Problem with index and left join  
1,978
Erland Isaksson
05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements  
28,212
Jacob Drew
05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements  
5,448
Anthony Willard
05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE  
2,458
Odimar Tomazeli
05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY  
12,302
Jerry Potokar
05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY  
2,226
Jerry Potokar
05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,375
Jerry Potokar
05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,160
Jerry Potokar
05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,661
Jerry Potokar
05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY  
2,371
Björn Steinbrink
05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,179
Jerry Potokar
05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,064
Beat Vontobel
05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,054
Jerry Potokar
05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,304
Jerry Potokar
05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,235
Beat Vontobel
05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,059
Jerry Potokar
05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,378
Beat Vontobel
05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,490
Jerry Potokar
05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY  
5,765
Beat Vontobel
05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,879
Jerry Potokar
05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,421
Jerry Potokar
05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,470
Beat Vontobel
05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY  
5,112
Beat Vontobel
05/03/2006 09:11AM
Query Optimization  
3,406
Joe Taylor
04/26/2006 01:57PM
Re: Query Optimization  
1,769
Björn Steinbrink
05/03/2006 03:31PM
Re: Query Optimization  
1,869
Bill Karwin
04/26/2006 04:46PM
Re: Query Optimization  
1,794
Apachez
04/26/2006 04:56PM
Re: Query Optimization  
1,951
Bill Karwin
04/26/2006 05:29PM
Re: Query Optimization  
1,787
Joe Taylor
05/03/2006 03:11PM
Optimizing Substring Query  
5,676
spicedh
05/02/2006 01:01PM
Re: Optimizing Substring Query  
1,833
Peter Brawley
05/02/2006 02:39PM
Re: Optimizing Substring Query  
2,418
spicedh
05/02/2006 02:45PM
Re: Optimizing Substring Query  
1,623
Peter Brawley
05/02/2006 03:00PM
Re: Optimizing Substring Query  
2,256
Björn Steinbrink
05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause  
13,067
John McNally
04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,792
Apachez
04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause  
3,967
Sebastien Caisse
05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause  
4,040
Apachez
05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,182
Sebastien Caisse
05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,071
Apachez
05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,832
Björn Steinbrink
05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions  
19,044
Tristan Crombez
04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions  
7,681
Bill Karwin
04/30/2006 03:55PM
table design and query opimization  
2,490
prasanna
04/19/2006 02:11AM
Re: table design and query opimization  
1,794
Sebastien Caisse
04/27/2006 11:27AM
Re: table design and query opimization  
1,427
prasanna
04/19/2006 10:25PM
Re: table design and query opimization  
1,797
moraless92
04/19/2006 10:29AM
Optimizer not working adequately  
2,282
emilio.ayllon
04/25/2006 07:41PM
Re: Optimizer not working adequately  
1,667
EM Ayllon
04/26/2006 09:43AM
Re: Optimizer not working adequately  
1,709
Björn Steinbrink
04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing  
5,914
Dominique PRUNIER
04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing  
2,756
James Day
04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing  
2,992
Dominique PRUNIER
04/23/2006 08:04PM
Using "optimize table"  
2,292
Bozhidar Bozhanov
04/21/2006 04:02AM
Re: Using "optimize table"  
1,613
Apachez
04/21/2006 04:26AM
where condition optimization  
2,758
Srivats Chandrasekaran
02/27/2006 03:57AM
Re: where condition optimization  
1,674
Bob Field
04/19/2006 09:51AM
Re: where condition optimization  
1,693
prasanna
04/19/2006 02:26AM
Database structure question  
2,419
Bozhidar Bozhanov
04/17/2006 10:29AM
Re: Database structure question  
1,670
Bill Karwin
04/17/2006 10:54AM
High RAM usage  
3,376
Nathan Bartell
04/12/2006 08:25AM
Re: High RAM usage  
2,159
Bill Karwin
04/12/2006 11:33AM
LEFT JOIN Issue in 5.0  
3,346
Martin Dubuc
04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0  
1,716
Roman Kolcun
04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0  
1,719
Martin Dubuc
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
1,803
Martin Dubuc
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
1,843
Bob Field
04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0  
1,907
Martin Dubuc
04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0  
1,823
Bob Field
04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0  
1,752
Martin Dubuc
04/10/2006 11:38AM
Index merge optimization (with OR) and table joins  
2,253
Stuart Brooks
04/07/2006 06:56AM
data design optimization  
2,574
BattleMan BattleClan
03/30/2006 07:44AM
Re: data design optimization  
1,924
BattleMan BattleClan
04/01/2006 06:38AM
Re: data design optimization  
1,699
Peter Brawley
03/31/2006 04:59PM
Re: data design optimization  
1,826
BattleMan BattleClan
03/31/2006 01:42PM
Re: data design optimization  
1,801
Peter Brawley
03/30/2006 04:03PM
Re: data design optimization  
1,865
BattleMan BattleClan
03/30/2006 01:41PM
Query Statement  
2,276
BattleMan BattleClan
03/30/2006 01:43PM
Re: data design optimization  
1,710
Peter Brawley
03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)  
2,342
feeling wu
03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background  
2,422
Mathias Bischoff
01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background  
1,746
Ulrich Schmid
03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN  
2,206
Timothy Brooks
03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN  
2,165
Peter Brawley
03/27/2006 06:23PM
Problem with LEF OUTER JOIN  
3,018
wdeveloper
03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN  
1,993
wdeveloper
03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN  
1,975
wdeveloper
03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN  
2,034
KimSeong Loh
03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN  
1,853
KimSeong Loh
03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN  
1,820
wdeveloper
03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN  
1,824
Sebastien Caisse
03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN  
1,825
KimSeong Loh
03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN  
1,732
Bob Field
03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN  
2,291
wdeveloper
03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN  
2,080
Bob Field
03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN  
1,893
wdeveloper
03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN  
1,741
Bob Field
03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)  
3,557
Beat Vontobel
03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,134
KimSeong Loh
03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,185
Beat Vontobel
03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
3,763
Björn Steinbrink
03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,122
Jay Pipes
03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,022
Beat Vontobel
03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,089
Beat Vontobel
03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes  
4,443
Nathan Cheng
03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes  
2,061
Harrison Fisk
03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes  
1,974
Nathan Cheng
03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes  
2,682
Björn Steinbrink
03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes  
1,903
Björn Steinbrink
03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes  
1,883
Björn Steinbrink
03/24/2006 11:02AM
Query Optimization  
2,472
Jorden Dunne
03/21/2006 06:10AM
Re: Query Optimization  
1,650
Peter Brawley
03/21/2006 08:24AM
Re: Query Optimization  
1,622
Jorden Dunne
03/21/2006 09:19AM
Re: Query Optimization  
1,747
Peter Brawley
03/21/2006 11:24AM
Mysql high cpu usage problem  
2,544
vikki saggu
01/07/2006 02:29PM
Re: Mysql high cpu usage problem  
1,949
Bruno B.
01/31/2006 07:13AM
Re: Mysql high cpu usage problem  
2,320
Tobias Marx
03/20/2006 05:26PM
Query  
2,407
Jorge Ferreira
03/15/2006 11:08AM
Re: Query  
1,781
Jorge Ferreira
03/15/2006 11:17AM
Re: Query  
1,743
Jay Pipes
03/15/2006 11:37AM
Re: Query  
1,675
Jorge Ferreira
03/17/2006 08:38AM
my.cnf option file , which one to use ?  
2,958
Ilan Goldman
03/07/2006 02:48PM
UP , JUMP , PLEASE HELP  
1,758
Ilan Goldman
03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"  
31,737
Solon Barns
03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,420
Solon Barns
03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,985
Jay Pipes
03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"  
16,195
Solon Barns
03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,666
Jay Pipes
03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,520
Jay Pipes
03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,065
Solon Barns
03/06/2006 08:27AM
MIN on an indexed field too slow  
3,689
Camelia Ticau
03/01/2006 01:58PM
Re: MIN on an indexed field too slow  
2,125
Björn Steinbrink
03/09/2006 06:04AM
Re: MIN on an indexed field too slow  
1,839
Apachez
03/02/2006 03:28PM
Re: MIN on an indexed field too slow  
1,898
Camelia Ticau
03/02/2006 11:38AM
Re: MIN on an indexed field too slow  
2,016
Apachez
03/01/2006 05:19PM
Re: MIN on an indexed field too slow  
1,997
Camelia Ticau
03/01/2006 04:54PM
Re: MIN on an indexed field too slow  
2,098
Apachez
03/01/2006 03:25PM
is HASH index being ignored  
3,499
Michal Carson
03/07/2006 10:17PM
Re: is HASH index being ignored  
1,941
Michal Carson
03/08/2006 10:59AM
Re: is HASH index being ignored  
1,952
Felix Geerinckx
03/08/2006 04:32AM
Re: is HASH index being ignored  
1,805
KimSeong Loh
03/08/2006 07:50PM
Urgent Optimized QUERY needed::  
2,912
Mohammed Abdullah All Marbin
03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::  
1,748
Bob Field
03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour  
4,219
Victor Perez Roche
02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,983
Edwin DeSouza
02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,905
Victor Perez Roche
02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,838
Edwin DeSouza
03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,067
Victor Perez Roche
02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,007
Olaf van der Spek
02/20/2006 09:20AM
Range query performance question  
6,200
Camelia Ticau
02/27/2006 01:52PM
Re: Range query performance question  
2,434
Jay Pipes
02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')  
29,224
yoderek
02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')  
12,345
Jay Pipes
02/23/2006 11:12PM
Need recommendation regarding IN expression  
2,905
Solon Barns
02/22/2006 12:52PM
Re: Need recommendation regarding IN expression  
1,973
Jay Pipes
02/22/2006 01:29PM
Re: Need recommendation regarding IN expression  
1,693
Solon Barns
02/23/2006 12:59AM
Re: Need recommendation regarding IN expression  
2,005
Jay Pipes
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.