Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Cluster 7.1.33 has been released 10/21/2014 04:54AM
MySQL Cluster 7.3.7 has been released 10/17/2014 07:46PM
MySQL Cluster 7.2.18 has been released 10/16/2014 12:07PM
MySQL Enterprise Monitor 3.0.15 has been released 10/01/2014 10:49AM
MySQL Connector/NET 6.9.4 has been released 09/26/2014 04:00PM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
Subject Views Written By Posted
Optimize Query with SUM() and CASE... statements   18,466 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,267 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   1,813 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   10,992 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,633 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   1,920 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,754 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,066 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   1,867 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,766 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,473 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,641 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,858 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,814 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,572 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,624 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,010 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   4,991 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,329 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,070 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,021 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,622 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,396 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,484 05/03/2006 03:31PM
Re: Query Optimization   1,500 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,485 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,522 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,509 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,217 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,434 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   1,996 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,295 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   1,841 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   6,794 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   2,836 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,548 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   2,723 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   2,713 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   2,632 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,382 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   13,927 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   5,748 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   1,910 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,461 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,089 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,477 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   1,770 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,402 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,421 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,075 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,029 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   1,959 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   1,842 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,373 Apachez 04/21/2006 04:26AM
where condition optimization   2,120 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,442 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,459 prasanna 04/19/2006 02:26AM
Database structure question   1,862 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,429 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,471 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,824 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,318 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,484 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,469 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,531 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,480 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,570 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,528 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,486 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,766 Stuart Brooks 04/07/2006 06:56AM
data design optimization   1,970 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,565 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,420 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,465 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,451 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,506 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,679 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,461 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,800 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   1,975 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,503 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,825 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,866 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,218 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,635 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,640 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,650 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,520 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,525 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,436 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,469 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,411 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   1,871 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,670 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,595 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,462 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   2,755 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,827 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,746 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,465 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,729 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,695 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,780 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,623 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,628 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,602 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,107 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,583 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,549 03/24/2006 11:02AM
Query Optimization   1,944 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,478 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,406 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,520 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,075 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,700 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,093 Tobias Marx 03/20/2006 05:26PM
Query   1,846 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,506 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,441 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,467 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,332 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,512 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   29,828 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,651 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,367 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,511 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   16,985 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   18,823 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,479 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   2,681 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,645 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,517 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,612 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,640 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,604 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,694 Apachez 03/01/2006 03:25PM
is HASH index being ignored   2,421 Michal Carson 03/07/2006 10:17PM
Re: is HASH index being ignored   1,585 Michal Carson 03/08/2006 10:59AM
Re: is HASH index being ignored   1,666 Felix Geerinckx 03/08/2006 04:32AM
Re: is HASH index being ignored   1,539 KimSeong Loh 03/08/2006 07:50PM
Urgent Optimized QUERY needed::   2,215 Mohammed Abdullah All Marbin 03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::   1,507 Bob Field 03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour   3,258 Victor Perez Roche 02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,609 Edwin DeSouza 02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,517 Victor Perez Roche 02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,564 Edwin DeSouza 03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,587 Victor Perez Roche 02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,568 Olaf van der Spek 02/20/2006 09:20AM
Range query performance question   5,020 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,128 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   25,788 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   11,224 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   2,128 Solon Barns 02/22/2006 12:52PM
Re: Need recommendation regarding IN expression   1,565 Jay Pipes 02/22/2006 01:29PM
Re: Need recommendation regarding IN expression   1,360 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,541 Jay Pipes 02/23/2006 10:55AM
slow subquery   4,780 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,613 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   2,058 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,098 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,168 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,803 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,106 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,264 Brian Moon 12/07/2005 08:18AM
possible_keys exist but key is NULL   6,433 David McLaughlin 02/22/2006 11:29AM
Re: possible_keys exist but key is NULL   3,374 Thomas CORBIERE 02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY   1,873 Robert Bergs 02/21/2006 07:00AM
what is sql.exe doing?   2,782 Zilan Ciftci 02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN   1,519 Odimar Tomazeli 02/17/2006 01:37PM
Subquery performance improvements: When?   4,051 Olaf van der Spek 02/08/2006 10:07AM
Re: Subquery performance improvements: When?   1,981 Olaf van der Spek 02/14/2006 08:31AM
Re: Subquery performance improvements: When?   2,006 Robin Schumacher 02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24   2,078 Robert van Twillert 02/13/2006 12:47PM
SUBQUERY PROBLEM   2,281 Odimar Tomazeli 02/07/2006 04:21PM
Re: SUBQUERY PROBLEM   1,531 Odimar Tomazeli 02/13/2006 12:16PM
Re: SUBQUERY PROBLEM   1,627 Odimar Tomazeli 02/13/2006 11:17AM
Re: SUBQUERY PROBLEM   1,620 Jay Pipes 02/13/2006 11:22AM
Re: SUBQUERY PROBLEM   1,743 Odimar Tomazeli 02/13/2006 11:06AM
Re: SUBQUERY PROBLEM   1,560 Odimar Tomazeli 02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team   1,582 Odimar Tomazeli 02/08/2006 10:26AM
Re: SUBQUERY PROBLEM   1,641 Robin Schumacher 02/08/2006 04:57AM
Re: SUBQUERY PROBLEM   1,542 Jay Pipes 02/08/2006 03:59PM
Re: SUBQUERY PROBLEM   1,683 Jay Pipes 02/07/2006 04:45PM
Re: SUBQUERY PROBLEM   1,545 Jay Pipes 02/07/2006 04:52PM
Subqueries too slow   4,266 Andreas Schlicker 02/06/2006 11:08AM
Re: Subqueries too slow   1,761 Andreas Schlicker 02/10/2006 09:49AM
Re: Subqueries too slow   1,793 Jay Pipes 02/10/2006 10:43AM
Re: Subqueries too slow   1,756 Andreas Schlicker 02/10/2006 03:18AM
Re: Subqueries too slow   1,704 Jay Pipes 02/10/2006 08:51AM
Re: Subqueries too slow   1,969 Andreas Schlicker 02/07/2006 08:38AM
Re: Subqueries too slow   1,963 Robin Schumacher 02/06/2006 02:17PM
Re: Subqueries too slow   1,890 Andreas Schlicker 02/07/2006 07:06AM
Re: Subqueries too slow   2,116 Jay Pipes 02/06/2006 11:54AM
Is this query optimized?   1,807 zaw sze 02/09/2006 09:44PM
Question about Handler_write   2,471 Sebastien Caisse 02/09/2006 09:42AM
clash between unique and index keys   4,221 Kenneth Vogt 02/08/2006 12:58AM
Re: clash between unique and index keys   2,068 Kenneth Vogt 02/09/2006 12:04AM
Re: clash between unique and index keys   2,182 Jay Pipes 02/08/2006 04:40PM
Re: clash between unique and index keys   2,039 Kenneth Vogt 02/08/2006 05:44PM
Re: clash between unique and index keys   2,097 Jay Pipes 02/08/2006 05:49PM
qcache_free_blocks   7,177 Jacky Shu 02/07/2006 08:13AM
Re: qcache_free_blocks   4,107 Jay Pipes 02/07/2006 10:10AM
Re: qcache_free_blocks   3,634 Jacky Shu 02/07/2006 12:13PM
optimize   2,276 edson fernando 01/17/2006 02:41PM
Re: optimize   1,617 Sebastien Caisse 02/02/2006 09:02AM
Re: optimize   1,624 edson fernando 01/18/2006 09:07AM
Re: optimize   1,615 KimSeong Loh 01/17/2006 06:48PM
Double Index Performance   7,059 Jawad Laraqui 01/12/2006 02:21PM
Re: Double Index Performance   2,145 Sebastien Caisse 01/16/2006 06:24AM
Re: Double Index Performance   2,300 01/16/2006 08:46AM
Re: Double Index Performance   2,065 Sebastien Caisse 01/17/2006 06:45AM
Re: Double Index Performance   2,204 Sebastien Caisse 02/01/2006 01:05PM
Re: Double Index Performance   2,674 01/13/2006 05:18PM
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.