MySQL Forums
Forum List  »  Optimizer & Parser

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

Subject
Views
Written By
Posted
Great masses of files on database.  
2,709
Tronks
05/26/2006 01:06PM
Re: Great masses of files on database.  
1,639
Bill Karwin
05/26/2006 04:00PM
Re: Great masses of files on database.  
1,768
Peter Brawley
05/26/2006 08:59PM
Re: Great masses of files on database.  
2,062
Anthony Willard
05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY  
6,753
Jerome Asselin
05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
3,726
Jerome Asselin
05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,493
Jerome Asselin
05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,272
KimSeong Loh
05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,334
Jerome Asselin
05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY  
2,475
KimSeong Loh
05/14/2006 06:58PM
Optimization advise needed  
2,589
Jerry Tian
05/18/2006 12:51AM
Re: Optimization advise needed  
1,888
Jerry Tian
05/18/2006 12:57PM
Re: Optimization advise needed  
1,824
Björn Steinbrink
05/18/2006 01:51AM
index ignored  
2,375
Lauren Bradford
05/18/2006 12:00PM
mySQL performance problem on subqueries  
2,781
Falcon Meriva
05/15/2006 05:14AM
Re: mySQL performance problem on subqueries  
1,909
KimSeong Loh
05/15/2006 06:17PM
Re: mySQL performance problem on subqueries  
1,894
Peter Brawley
05/15/2006 12:31PM
How to optimize this query  
2,550
Yogesh Salvi
05/13/2006 04:36AM
Re: How to optimize this query  
1,943
Apachez
05/13/2006 08:22AM
Problem with index and left join  
4,444
Erland Isaksson
05/05/2006 03:04PM
Re: Problem with index and left join  
2,426
KimSeong Loh
05/09/2006 06:17PM
Re: Problem with index and left join  
2,509
Erland Isaksson
05/09/2006 10:44PM
Re: Problem with index and left join  
2,243
Apachez
05/09/2006 11:48PM
Re: Problem with index and left join  
2,250
Erland Isaksson
05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements  
33,220
Jacob Drew
05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements  
6,091
Anthony Willard
05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE  
2,879
Odimar Tomazeli
05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY  
12,823
Jerry Potokar
05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY  
2,553
Jerry Potokar
05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,615
Jerry Potokar
05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,442
Jerry Potokar
05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,976
Jerry Potokar
05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY  
2,648
Björn Steinbrink
05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,407
Jerry Potokar
05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,420
Beat Vontobel
05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,279
Jerry Potokar
05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,555
Jerry Potokar
05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,500
Beat Vontobel
05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,313
Jerry Potokar
05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY  
3,685
Beat Vontobel
05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,824
Jerry Potokar
05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY  
6,098
Beat Vontobel
05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY  
4,215
Jerry Potokar
05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY  
2,702
Jerry Potokar
05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY  
3,743
Beat Vontobel
05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY  
5,407
Beat Vontobel
05/03/2006 09:11AM
Query Optimization  
3,904
Joe Taylor
04/26/2006 01:57PM
Re: Query Optimization  
1,974
Björn Steinbrink
05/03/2006 03:31PM
Re: Query Optimization  
2,117
Bill Karwin
04/26/2006 04:46PM
Re: Query Optimization  
1,998
Apachez
04/26/2006 04:56PM
Re: Query Optimization  
2,207
Bill Karwin
04/26/2006 05:29PM
Re: Query Optimization  
1,962
Joe Taylor
05/03/2006 03:11PM
Optimizing Substring Query  
6,278
spicedh
05/02/2006 01:01PM
Re: Optimizing Substring Query  
2,078
Peter Brawley
05/02/2006 02:39PM
Re: Optimizing Substring Query  
2,722
spicedh
05/02/2006 02:45PM
Re: Optimizing Substring Query  
1,864
Peter Brawley
05/02/2006 03:00PM
Re: Optimizing Substring Query  
2,506
Björn Steinbrink
05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause  
15,499
John McNally
04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause  
5,530
Apachez
04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,500
Sebastien Caisse
05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause  
4,515
Apachez
05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,639
Sebastien Caisse
05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause  
4,569
Apachez
05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause  
5,417
Björn Steinbrink
05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions  
21,606
Tristan Crombez
04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions  
8,570
Bill Karwin
04/30/2006 03:55PM
table design and query opimization  
2,943
prasanna
04/19/2006 02:11AM
Re: table design and query opimization  
2,041
Sebastien Caisse
04/27/2006 11:27AM
Re: table design and query opimization  
1,660
prasanna
04/19/2006 10:25PM
Re: table design and query opimization  
2,042
moraless92
04/19/2006 10:29AM
Optimizer not working adequately  
2,660
emilio.ayllon
04/25/2006 07:41PM
Re: Optimizer not working adequately  
1,872
EM Ayllon
04/26/2006 09:43AM
Re: Optimizer not working adequately  
1,922
Björn Steinbrink
04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing  
7,504
Dominique PRUNIER
04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing  
3,283
James Day
04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing  
3,539
Dominique PRUNIER
04/23/2006 08:04PM
Using "optimize table"  
2,692
Bozhidar Bozhanov
04/21/2006 04:02AM
Re: Using "optimize table"  
1,807
Apachez
04/21/2006 04:26AM
where condition optimization  
3,077
Srivats Chandrasekaran
02/27/2006 03:57AM
Re: where condition optimization  
1,840
Bob Field
04/19/2006 09:51AM
Re: where condition optimization  
1,842
prasanna
04/19/2006 02:26AM
Database structure question  
2,776
Bozhidar Bozhanov
04/17/2006 10:29AM
Re: Database structure question  
1,849
Bill Karwin
04/17/2006 10:54AM
High RAM usage  
3,715
Nathan Bartell
04/12/2006 08:25AM
Re: High RAM usage  
2,335
Bill Karwin
04/12/2006 11:33AM
LEFT JOIN Issue in 5.0  
3,863
Martin Dubuc
04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0  
1,926
Roman Kolcun
04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0  
1,913
Martin Dubuc
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
1,998
Martin Dubuc
04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0  
2,079
Bob Field
04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0  
2,114
Martin Dubuc
04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0  
2,041
Bob Field
04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0  
1,977
Martin Dubuc
04/10/2006 11:38AM
Index merge optimization (with OR) and table joins  
2,581
Stuart Brooks
04/07/2006 06:56AM
data design optimization  
2,931
BattleMan BattleClan
03/30/2006 07:44AM
Re: data design optimization  
2,135
BattleMan BattleClan
04/01/2006 06:38AM
Re: data design optimization  
1,872
Peter Brawley
03/31/2006 04:59PM
Re: data design optimization  
2,003
BattleMan BattleClan
03/31/2006 01:42PM
Re: data design optimization  
1,998
Peter Brawley
03/30/2006 04:03PM
Re: data design optimization  
2,060
BattleMan BattleClan
03/30/2006 01:41PM
Query Statement  
2,493
BattleMan BattleClan
03/30/2006 01:43PM
Re: data design optimization  
1,887
Peter Brawley
03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)  
2,716
feeling wu
03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background  
2,711
Mathias Bischoff
01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background  
1,890
Ulrich Schmid
03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN  
2,472
Timothy Brooks
03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN  
2,373
Peter Brawley
03/27/2006 06:23PM
Problem with LEF OUTER JOIN  
3,394
wdeveloper
03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN  
2,219
wdeveloper
03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN  
2,174
wdeveloper
03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN  
2,252
KimSeong Loh
03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN  
2,058
KimSeong Loh
03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN  
1,999
wdeveloper
03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN  
2,028
Sebastien Caisse
03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN  
2,011
KimSeong Loh
03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN  
1,918
Bob Field
03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN  
2,538
wdeveloper
03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN  
2,315
Bob Field
03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN  
2,094
wdeveloper
03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN  
1,935
Bob Field
03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)  
3,981
Beat Vontobel
03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,333
KimSeong Loh
03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,400
Beat Vontobel
03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
3,942
Björn Steinbrink
03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,347
Jay Pipes
03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,225
Beat Vontobel
03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)  
2,262
Beat Vontobel
03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes  
4,884
Nathan Cheng
03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes  
2,260
Harrison Fisk
03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes  
2,165
Nathan Cheng
03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes  
2,927
Björn Steinbrink
03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes  
2,094
Björn Steinbrink
03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes  
2,099
Björn Steinbrink
03/24/2006 11:02AM
Query Optimization  
2,746
Jorden Dunne
03/21/2006 06:10AM
Re: Query Optimization  
1,801
Peter Brawley
03/21/2006 08:24AM
Re: Query Optimization  
1,759
Jorden Dunne
03/21/2006 09:19AM
Re: Query Optimization  
1,924
Peter Brawley
03/21/2006 11:24AM
Mysql high cpu usage problem  
2,813
vikki saggu
01/07/2006 02:29PM
Re: Mysql high cpu usage problem  
2,104
Bruno B.
01/31/2006 07:13AM
Re: Mysql high cpu usage problem  
2,475
Tobias Marx
03/20/2006 05:26PM
Query  
2,714
Jorge Ferreira
03/15/2006 11:08AM
Re: Query  
1,958
Jorge Ferreira
03/15/2006 11:17AM
Re: Query  
1,929
Jay Pipes
03/15/2006 11:37AM
Re: Query  
1,828
Jorge Ferreira
03/17/2006 08:38AM
my.cnf option file , which one to use ?  
3,346
Ilan Goldman
03/07/2006 02:48PM
UP , JUMP , PLEASE HELP  
1,932
Ilan Goldman
03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"  
33,147
Solon Barns
03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,825
Solon Barns
03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,326
Jay Pipes
03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"  
16,571
Solon Barns
03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,095
Jay Pipes
03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,922
Jay Pipes
03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,500
Solon Barns
03/06/2006 08:27AM
MIN on an indexed field too slow  
4,317
Camelia Ticau
03/01/2006 01:58PM
Re: MIN on an indexed field too slow  
2,463
Björn Steinbrink
03/09/2006 06:04AM
Re: MIN on an indexed field too slow  
2,042
Apachez
03/02/2006 03:28PM
Re: MIN on an indexed field too slow  
2,118
Camelia Ticau
03/02/2006 11:38AM
Re: MIN on an indexed field too slow  
2,228
Apachez
03/01/2006 05:19PM
Re: MIN on an indexed field too slow  
2,245
Camelia Ticau
03/01/2006 04:54PM
Re: MIN on an indexed field too slow  
2,359
Apachez
03/01/2006 03:25PM
is HASH index being ignored  
3,877
Michal Carson
03/07/2006 10:17PM
Re: is HASH index being ignored  
2,156
Michal Carson
03/08/2006 10:59AM
Re: is HASH index being ignored  
2,228
Felix Geerinckx
03/08/2006 04:32AM
Re: is HASH index being ignored  
2,024
KimSeong Loh
03/08/2006 07:50PM
Urgent Optimized QUERY needed::  
3,347
Mohammed Abdullah All Marbin
03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::  
1,920
Bob Field
03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour  
4,689
Victor Perez Roche
02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,179
Edwin DeSouza
02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,112
Victor Perez Roche
02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,053
Edwin DeSouza
03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,405
Victor Perez Roche
02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,229
Olaf van der Spek
02/20/2006 09:20AM
Range query performance question  
6,717
Camelia Ticau
02/27/2006 01:52PM
Re: Range query performance question  
2,624
Jay Pipes
02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')  
30,204
yoderek
02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')  
12,786
Jay Pipes
02/23/2006 11:12PM
Need recommendation regarding IN expression  
3,322
Solon Barns
02/22/2006 12:52PM
Re: Need recommendation regarding IN expression  
2,212
Jay Pipes
02/22/2006 01:29PM
Re: Need recommendation regarding IN expression  
1,942
Solon Barns
02/23/2006 12:59AM
Re: Need recommendation regarding IN expression  
2,232
Jay Pipes
02/23/2006 10:55AM
slow subquery  
6,659
Michael Schnell
12/01/2005 03:33AM
Re: slow subquery  
5,233
Olaf van der Spek
02/23/2006 08:04AM
Re: slow subquery  
2,635
mysql.com
02/22/2006 01:06PM
Re: slow subquery  
2,675
Igor Babaev
12/19/2005 11:58PM
Re: slow subquery  
3,174
Matthias Horn
12/30/2005 12:43PM
Re: slow subquery (query is fast)  
3,416
Matthias Horn
12/30/2005 02:25PM
Re: slow subquery  
2,732
Michael Schnell
12/09/2005 02:32PM
Re: slow subquery  
2,923
Brian Moon
12/07/2005 08:18AM
possible_keys exist but key is NULL  
10,801
David McLaughlin
02/22/2006 11:29AM
Re: possible_keys exist but key is NULL  
4,506
Thomas CORBIERE
02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY  
2,747
Robert Bergs
02/21/2006 07:00AM
what is sql.exe doing?  
3,954
Zilan Ciftci
02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN  
2,361
Odimar Tomazeli
02/17/2006 01:37PM
Subquery performance improvements: When?  
5,438
Olaf van der Spek
02/08/2006 10:07AM
Re: Subquery performance improvements: When?  
2,505
Olaf van der Spek
02/14/2006 08:31AM
Re: Subquery performance improvements: When?  
2,493
Robin Schumacher
02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24  
2,841
Robert van Twillert
02/13/2006 12:47PM
SUBQUERY PROBLEM  
3,469
Odimar Tomazeli
02/07/2006 04:21PM
Re: SUBQUERY PROBLEM  
2,141
Odimar Tomazeli
02/13/2006 12:16PM
Re: SUBQUERY PROBLEM  
2,342
Odimar Tomazeli
02/13/2006 11:17AM
Re: SUBQUERY PROBLEM  
2,272
Jay Pipes
02/13/2006 11:22AM
Re: SUBQUERY PROBLEM  
2,435
Odimar Tomazeli
02/13/2006 11:06AM
Re: SUBQUERY PROBLEM  
2,199
Odimar Tomazeli
02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team  
2,226
Odimar Tomazeli
02/08/2006 10:26AM
Re: SUBQUERY PROBLEM  
2,335
Robin Schumacher
02/08/2006 04:57AM
Re: SUBQUERY PROBLEM  
2,179
Jay Pipes
02/08/2006 03:59PM
Re: SUBQUERY PROBLEM  
2,326
Jay Pipes
02/07/2006 04:45PM
Re: SUBQUERY PROBLEM  
2,194
Jay Pipes
02/07/2006 04:52PM
Pages:
« 1
...
15 16 17 18 19 »
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.