Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Proxy 0.8.5 alpha has been released 09/05/2014 03:15PM
MySQL Workbench 6.2.2 RC has been released 09/05/2014 03:05PM
MySQL Connector/NET 6.9.3 GA has been released 09/03/2014 06:02AM
MySQL Enterprise Monitor 3.0.14 has been released 09/02/2014 02:37PM
MySQL Enterprise Backup 3.11.0 has been released 09/02/2014 10:13AM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
Subject Views Written By Posted
Optimizing Substring Query   4,192 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,429 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   1,990 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,293 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   1,834 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   6,708 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   2,805 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,531 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   2,703 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   2,686 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   2,607 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,359 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   13,832 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   5,713 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   1,900 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,459 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,474 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   1,762 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,399 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,420 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,052 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,017 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   1,952 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   1,842 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,371 Apachez 04/21/2006 04:26AM
where condition optimization   2,116 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,440 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,458 prasanna 04/19/2006 02:26AM
Database structure question   1,854 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,428 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,451 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,818 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,306 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,483 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,467 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,527 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,474 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,568 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,525 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,483 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,763 Stuart Brooks 04/07/2006 06:56AM
data design optimization   1,963 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,559 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,419 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,461 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,449 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,505 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,674 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,459 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,795 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   1,969 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,501 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,819 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,865 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,199 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,630 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,635 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,649 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,518 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,523 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,433 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,408 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   1,868 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,667 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,594 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,458 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   2,741 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,823 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,740 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,460 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,723 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,689 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,772 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,609 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,627 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,599 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,096 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,580 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,547 03/24/2006 11:02AM
Query Optimization   1,937 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,477 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,405 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,517 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,066 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,699 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,091 Tobias Marx 03/20/2006 05:26PM
Query   1,830 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,504 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,439 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,464 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,321 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,511 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   29,773 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,629 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,347 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,490 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   16,967 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   18,799 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,460 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   2,666 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,641 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,514 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,608 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,636 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,601 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,688 Apachez 03/01/2006 03:25PM
is HASH index being ignored   2,404 Michal Carson 03/07/2006 10:17PM
Re: is HASH index being ignored   1,582 Michal Carson 03/08/2006 10:59AM
Re: is HASH index being ignored   1,663 Felix Geerinckx 03/08/2006 04:32AM
Re: is HASH index being ignored   1,537 KimSeong Loh 03/08/2006 07:50PM
Urgent Optimized QUERY needed::   2,207 Mohammed Abdullah All Marbin 03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::   1,504 Bob Field 03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour   3,243 Victor Perez Roche 02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,604 Edwin DeSouza 02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,513 Victor Perez Roche 02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,561 Edwin DeSouza 03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,580 Victor Perez Roche 02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,560 Olaf van der Spek 02/20/2006 09:20AM
Range query performance question   4,998 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,122 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   25,694 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   11,190 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   2,119 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,356 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,540 Jay Pipes 02/23/2006 10:55AM
slow subquery   4,766 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,605 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   2,054 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,096 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,161 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,797 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,102 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,260 Brian Moon 12/07/2005 08:18AM
possible_keys exist but key is NULL   6,409 David McLaughlin 02/22/2006 11:29AM
Re: possible_keys exist but key is NULL   3,368 Thomas CORBIERE 02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY   1,867 Robert Bergs 02/21/2006 07:00AM
what is sql.exe doing?   2,772 Zilan Ciftci 02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN   1,510 Odimar Tomazeli 02/17/2006 01:37PM
Subquery performance improvements: When?   4,034 Olaf van der Spek 02/08/2006 10:07AM
Re: Subquery performance improvements: When?   1,979 Olaf van der Spek 02/14/2006 08:31AM
Re: Subquery performance improvements: When?   2,004 Robin Schumacher 02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24   2,073 Robert van Twillert 02/13/2006 12:47PM
SUBQUERY PROBLEM   2,266 Odimar Tomazeli 02/07/2006 04:21PM
Re: SUBQUERY PROBLEM   1,529 Odimar Tomazeli 02/13/2006 12:16PM
Re: SUBQUERY PROBLEM   1,623 Odimar Tomazeli 02/13/2006 11:17AM
Re: SUBQUERY PROBLEM   1,617 Jay Pipes 02/13/2006 11:22AM
Re: SUBQUERY PROBLEM   1,740 Odimar Tomazeli 02/13/2006 11:06AM
Re: SUBQUERY PROBLEM   1,556 Odimar Tomazeli 02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team   1,579 Odimar Tomazeli 02/08/2006 10:26AM
Re: SUBQUERY PROBLEM   1,638 Robin Schumacher 02/08/2006 04:57AM
Re: SUBQUERY PROBLEM   1,540 Jay Pipes 02/08/2006 03:59PM
Re: SUBQUERY PROBLEM   1,677 Jay Pipes 02/07/2006 04:45PM
Re: SUBQUERY PROBLEM   1,544 Jay Pipes 02/07/2006 04:52PM
Subqueries too slow   4,255 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,789 Jay Pipes 02/10/2006 10:43AM
Re: Subqueries too slow   1,749 Andreas Schlicker 02/10/2006 03:18AM
Re: Subqueries too slow   1,702 Jay Pipes 02/10/2006 08:51AM
Re: Subqueries too slow   1,966 Andreas Schlicker 02/07/2006 08:38AM
Re: Subqueries too slow   1,959 Robin Schumacher 02/06/2006 02:17PM
Re: Subqueries too slow   1,888 Andreas Schlicker 02/07/2006 07:06AM
Re: Subqueries too slow   2,111 Jay Pipes 02/06/2006 11:54AM
Is this query optimized?   1,801 zaw sze 02/09/2006 09:44PM
Question about Handler_write   2,462 Sebastien Caisse 02/09/2006 09:42AM
clash between unique and index keys   4,195 Kenneth Vogt 02/08/2006 12:58AM
Re: clash between unique and index keys   2,065 Kenneth Vogt 02/09/2006 12:04AM
Re: clash between unique and index keys   2,178 Jay Pipes 02/08/2006 04:40PM
Re: clash between unique and index keys   2,037 Kenneth Vogt 02/08/2006 05:44PM
Re: clash between unique and index keys   2,094 Jay Pipes 02/08/2006 05:49PM
qcache_free_blocks   7,159 Jacky Shu 02/07/2006 08:13AM
Re: qcache_free_blocks   4,097 Jay Pipes 02/07/2006 10:10AM
Re: qcache_free_blocks   3,629 Jacky Shu 02/07/2006 12:13PM
optimize   2,269 edson fernando 01/17/2006 02:41PM
Re: optimize   1,615 Sebastien Caisse 02/02/2006 09:02AM
Re: optimize   1,624 edson fernando 01/18/2006 09:07AM
Re: optimize   1,614 KimSeong Loh 01/17/2006 06:48PM
Double Index Performance   7,042 Jawad Laraqui 01/12/2006 02:21PM
Re: Double Index Performance   2,141 Sebastien Caisse 01/16/2006 06:24AM
Re: Double Index Performance   2,298 01/16/2006 08:46AM
Re: Double Index Performance   2,065 Sebastien Caisse 01/17/2006 06:45AM
Re: Double Index Performance   2,200 Sebastien Caisse 02/01/2006 01:05PM
Re: Double Index Performance   2,672 01/13/2006 05:18PM
'where' with 'in' doesn't use index?   2,277 Vlado Kurelec 01/24/2006 05:25AM
Re: 'where' with 'in' doesn't use index?   1,657 Vlado Kurelec 02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?   1,643 Robin Schumacher 01/30/2006 04:45PM
subquery breaks optimization   2,051 Kiryll Mirnenko 01/20/2006 06:51AM
Re: subquery breaks optimization   1,638 Robin Schumacher 01/24/2006 07:14PM
mysql dont use my Index?   2,057 Johannes Fosseus 01/12/2006 08:22AM
Re: mysql dont use my Index?   1,606 Jay Pipes 01/18/2006 10:36PM
does Select values effect index selection?   2,257 ade br 01/10/2006 09:30AM
Re: does Select values effect index selection?   1,651 Jay Pipes 01/10/2006 05:04PM
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.