Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.24 has been released 08/28/2015 01:07PM
MySQL Connector/NET 6.9.7 has been released 08/05/2015 06:38AM
MySQL Community Server 5.7.8 has been released (part 3/3) 08/03/2015 09:14AM
MySQL Community Server 5.7.8 has been released (part 2/3) 08/03/2015 09:12AM
MySQL Community Server 5.7.8 has been released (part 1/3) 08/03/2015 09:09AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
fast way to delete records?   12,352 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,419 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,049 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   5,860 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,167 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   25,696 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   4,959 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,515 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,519 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   6,866 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,285 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,573 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,074 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,632 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,231 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,308 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,330 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,242 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,240 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,045 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,386 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,654 bj√∂rn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,169 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   1,956 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   1,981 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,031 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,262 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,470 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,576 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,466 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,111 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,957 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,793 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,830 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,987 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   1,985 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,446 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,504 05/18/2006 01:51AM
index ignored   1,787 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,010 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,474 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,522 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,838 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,450 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,142 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   1,951 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,019 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,796 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,689 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   19,695 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,408 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   1,930 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,392 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,716 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,014 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,850 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,213 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   1,969 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,878 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,620 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,718 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,919 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,901 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,654 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,793 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,125 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,191 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,470 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,148 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,119 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,736 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,632 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,535 05/03/2006 03:31PM
Re: Query Optimization   1,574 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,543 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,610 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,577 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,637 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,525 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,078 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,362 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   1,932 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   7,564 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,050 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,768 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   2,919 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   2,952 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   2,904 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,654 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   14,923 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,082 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,056 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,522 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,154 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,543 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   1,909 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,451 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,493 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,286 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,123 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,039 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   1,939 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,433 Apachez 04/21/2006 04:26AM
where condition optimization   2,304 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,488 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,517 prasanna 04/19/2006 02:26AM
Database structure question   1,983 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,485 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,707 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,896 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,564 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,529 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,517 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,592 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,549 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,634 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,595 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,539 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,882 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,128 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,642 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,499 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,533 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,533 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,606 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,788 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,516 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,927 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,080 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,556 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,930 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,928 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,474 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,724 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,743 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,745 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,613 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,609 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,534 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,556 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,486 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   1,969 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,775 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,680 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,559 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   2,980 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,901 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,838 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,537 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,854 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,780 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,874 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,836 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,730 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,704 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,269 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,687 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,634 03/24/2006 11:02AM
Query Optimization   2,104 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,523 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,454 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,570 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,215 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,750 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,147 Tobias Marx 03/20/2006 05:26PM
Query   2,006 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,566 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,507 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,510 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,481 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,558 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   30,446 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,855 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,544 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,657 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,141 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   19,001 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,649 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   2,891 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,753 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,597 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,685 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,730 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,710 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,815 Apachez 03/01/2006 03:25PM
is HASH index being ignored   2,721 Michal Carson 03/07/2006 10:17PM
Re: is HASH index being ignored   1,653 Michal Carson 03/08/2006 10:59AM
Re: is HASH index being ignored   1,725 Felix Geerinckx 03/08/2006 04:32AM
Re: is HASH index being ignored   1,594 KimSeong Loh 03/08/2006 07:50PM
Urgent Optimized QUERY needed::   2,390 Mohammed Abdullah All Marbin 03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::   1,551 Bob Field 03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour   3,440 Victor Perez Roche 02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,707 Edwin DeSouza 02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,604 Victor Perez Roche 02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,609 Edwin DeSouza 03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,675 Victor Perez Roche 02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,628 Olaf van der Spek 02/20/2006 09:20AM
Range query performance question   5,334 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,204 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   26,593 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   11,481 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   2,265 Solon Barns 02/22/2006 12:52PM
Re: Need recommendation regarding IN expression   1,634 Jay Pipes 02/22/2006 01:29PM
Re: Need recommendation regarding IN expression   1,424 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,631 Jay Pipes 02/23/2006 10:55AM
slow subquery   5,113 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,717 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   2,143 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,175 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,307 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,870 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,187 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,361 Brian Moon 12/07/2005 08:18AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17

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.