Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Workbench 6.2.5 GA has been released 03/03/2015 09:56AM
MySQL Connector/NET 6.8.5 has been released 03/03/2015 09:48AM
MySQL Enterprise Monitor 3.0.20 has been released 02/26/2015 03:28PM
MySQL Cluster Manager 1.3.4 has been released 02/26/2015 08:51AM
MySQL Cluster 7.4.4 has been released 02/26/2015 08:34AM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
Subject Views Written By Posted
Optimization advise needed   1,907 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,425 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,478 05/18/2006 01:51AM
index ignored   1,729 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   1,940 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,447 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,496 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,798 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,436 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,019 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   1,903 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   1,971 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,761 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,653 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   18,975 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,328 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   1,878 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,195 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,677 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   1,980 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,814 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,159 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   1,924 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,836 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,562 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,685 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,893 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,868 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,612 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,710 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,070 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,087 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,407 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,107 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,072 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,685 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,520 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,508 05/03/2006 03:31PM
Re: Query Optimization   1,545 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,508 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,577 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,549 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,482 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,481 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,035 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,323 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   1,888 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   7,184 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   2,926 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,654 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   2,811 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   2,820 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   2,764 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,494 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   14,320 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   5,882 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   1,979 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,492 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,131 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,511 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   1,844 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,427 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,461 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,169 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,070 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   1,994 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   1,885 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,406 Apachez 04/21/2006 04:26AM
where condition optimization   2,203 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,466 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,486 prasanna 04/19/2006 02:26AM
Database structure question   1,920 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,460 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,595 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,863 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,456 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,505 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,494 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,560 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,515 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,603 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,559 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,510 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,824 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,052 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,607 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,475 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,504 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,509 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,564 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,753 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,492 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,856 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,032 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,534 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,879 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,900 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,360 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,691 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,698 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,709 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,575 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,573 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,499 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,528 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,457 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   1,924 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,735 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,649 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,523 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   2,884 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,868 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,792 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,498 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,800 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,748 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,831 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,744 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,694 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,661 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,169 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,655 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,611 03/24/2006 11:02AM
Query Optimization   2,033 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,503 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,433 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,548 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,149 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,727 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,121 Tobias Marx 03/20/2006 05:26PM
Query   1,947 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,534 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,473 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,487 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,413 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,534 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   30,141 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,747 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,452 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,577 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,047 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   18,906 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,568 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   2,789 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,709 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,562 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,653 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,687 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,670 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,756 Apachez 03/01/2006 03:25PM
is HASH index being ignored   2,548 Michal Carson 03/07/2006 10:17PM
Re: is HASH index being ignored   1,618 Michal Carson 03/08/2006 10:59AM
Re: is HASH index being ignored   1,696 Felix Geerinckx 03/08/2006 04:32AM
Re: is HASH index being ignored   1,572 KimSeong Loh 03/08/2006 07:50PM
Urgent Optimized QUERY needed::   2,292 Mohammed Abdullah All Marbin 03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::   1,524 Bob Field 03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour   3,366 Victor Perez Roche 02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,668 Edwin DeSouza 02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,566 Victor Perez Roche 02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,588 Edwin DeSouza 03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,633 Victor Perez Roche 02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,598 Olaf van der Spek 02/20/2006 09:20AM
Range query performance question   5,170 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,167 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   26,119 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   11,326 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   2,208 Solon Barns 02/22/2006 12:52PM
Re: Need recommendation regarding IN expression   1,613 Jay Pipes 02/22/2006 01:29PM
Re: Need recommendation regarding IN expression   1,397 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,596 Jay Pipes 02/23/2006 10:55AM
slow subquery   4,934 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,677 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   2,105 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,143 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,247 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,837 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,156 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,313 Brian Moon 12/07/2005 08:18AM
possible_keys exist but key is NULL   6,597 David McLaughlin 02/22/2006 11:29AM
Re: possible_keys exist but key is NULL   3,402 Thomas CORBIERE 02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY   1,936 Robert Bergs 02/21/2006 07:00AM
what is sql.exe doing?   2,876 Zilan Ciftci 02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN   1,572 Odimar Tomazeli 02/17/2006 01:37PM
Subquery performance improvements: When?   4,159 Olaf van der Spek 02/08/2006 10:07AM
Re: Subquery performance improvements: When?   2,013 Olaf van der Spek 02/14/2006 08:31AM
Re: Subquery performance improvements: When?   2,038 Robin Schumacher 02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24   2,132 Robert van Twillert 02/13/2006 12:47PM
SUBQUERY PROBLEM   2,395 Odimar Tomazeli 02/07/2006 04:21PM
Re: SUBQUERY PROBLEM   1,603 Odimar Tomazeli 02/13/2006 12:16PM
Re: SUBQUERY PROBLEM   1,689 Odimar Tomazeli 02/13/2006 11:17AM
Re: SUBQUERY PROBLEM   1,668 Jay Pipes 02/13/2006 11:22AM
Re: SUBQUERY PROBLEM   1,805 Odimar Tomazeli 02/13/2006 11:06AM
Re: SUBQUERY PROBLEM   1,634 Odimar Tomazeli 02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team   1,661 Odimar Tomazeli 02/08/2006 10:26AM
Re: SUBQUERY PROBLEM   1,690 Robin Schumacher 02/08/2006 04:57AM
Re: SUBQUERY PROBLEM   1,593 Jay Pipes 02/08/2006 03:59PM
Re: SUBQUERY PROBLEM   1,718 Jay Pipes 02/07/2006 04:45PM
Re: SUBQUERY PROBLEM   1,609 Jay Pipes 02/07/2006 04:52PM
Subqueries too slow   4,384 Andreas Schlicker 02/06/2006 11:08AM
Re: Subqueries too slow   1,834 Andreas Schlicker 02/10/2006 09:49AM
Re: Subqueries too slow   1,896 Jay Pipes 02/10/2006 10:43AM
Re: Subqueries too slow   1,878 Andreas Schlicker 02/10/2006 03:18AM
Re: Subqueries too slow   1,772 Jay Pipes 02/10/2006 08:51AM
Re: Subqueries too slow   2,027 Andreas Schlicker 02/07/2006 08:38AM
Re: Subqueries too slow   2,035 Robin Schumacher 02/06/2006 02:17PM
Re: Subqueries too slow   1,984 Andreas Schlicker 02/07/2006 07:06AM
Re: Subqueries too slow   2,201 Jay Pipes 02/06/2006 11:54AM
Is this query optimized?   1,860 zaw sze 02/09/2006 09:44PM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16

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.