Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/J 5.1.35 has been released 03/24/2015 04:19AM
MySQL Cluster 7.4.5 has been released 03/20/2015 12:52PM
MySQL Connector/C 6.1.6 has been released 03/20/2015 11:23AM
MySQL Enterprise Backup 3.12.0 has been released 03/16/2015 10:55AM
MySQL Workbench 6.3.2 RC has been released 03/13/2015 06:57AM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
Subject Views Written By Posted
Great masses of files on database.   1,971 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,235 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,445 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,552 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,325 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,070 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,932 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,764 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,799 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,962 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   1,915 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,430 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,481 05/18/2006 01:51AM
index ignored   1,736 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   1,950 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,450 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,501 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,806 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,437 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,043 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   1,911 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   1,977 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,765 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,657 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   19,046 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,335 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   1,887 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,234 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,685 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   1,982 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,820 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,171 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   1,927 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,842 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,575 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,694 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,897 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,872 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,621 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,723 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,081 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,103 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,415 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,112 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,076 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,692 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,536 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,512 05/03/2006 03:31PM
Re: Query Optimization   1,551 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,512 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,583 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,553 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,511 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,486 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,039 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,325 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   1,894 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   7,261 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   2,947 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,676 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   2,829 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   2,847 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   2,792 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,519 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   14,393 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   5,908 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,003 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,496 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,135 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,516 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   1,853 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,431 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,469 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,181 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,076 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,000 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   1,893 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,408 Apachez 04/21/2006 04:26AM
where condition optimization   2,242 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,469 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,490 prasanna 04/19/2006 02:26AM
Database structure question   1,931 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,464 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,619 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,864 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,480 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,508 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,495 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,562 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,523 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,604 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,564 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,515 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,836 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,068 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,612 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,480 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,510 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,514 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,573 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,760 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,498 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,870 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,043 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,537 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,891 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,904 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,383 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,695 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,711 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,718 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,582 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,577 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,504 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,532 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,460 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   1,931 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,739 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,652 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,528 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   2,898 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,871 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,798 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,503 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,820 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,755 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,838 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,760 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,698 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,670 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,186 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,660 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,613 03/24/2006 11:02AM
Query Optimization   2,047 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,507 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,437 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,551 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,156 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,730 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,124 Tobias Marx 03/20/2006 05:26PM
Query   1,957 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,539 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,479 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,489 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,425 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,186 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,760 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,462 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,583 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,059 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   18,918 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,588 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   2,805 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,718 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,567 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,658 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,696 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,677 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,768 Apachez 03/01/2006 03:25PM
is HASH index being ignored   2,576 Michal Carson 03/07/2006 10:17PM
Re: is HASH index being ignored   1,626 Michal Carson 03/08/2006 10:59AM
Re: is HASH index being ignored   1,699 Felix Geerinckx 03/08/2006 04:32AM
Re: is HASH index being ignored   1,575 KimSeong Loh 03/08/2006 07:50PM
Urgent Optimized QUERY needed::   2,304 Mohammed Abdullah All Marbin 03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::   1,528 Bob Field 03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour   3,377 Victor Perez Roche 02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,672 Edwin DeSouza 02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,573 Victor Perez Roche 02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,590 Edwin DeSouza 03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,639 Victor Perez Roche 02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,601 Olaf van der Spek 02/20/2006 09:20AM
Range query performance question   5,199 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,172 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   26,183 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   11,345 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   2,215 Solon Barns 02/22/2006 12:52PM
Re: Need recommendation regarding IN expression   1,617 Jay Pipes 02/22/2006 01:29PM
Re: Need recommendation regarding IN expression   1,402 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,602 Jay Pipes 02/23/2006 10:55AM
slow subquery   4,957 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,684 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   2,110 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,149 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,258 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,840 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,161 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,321 Brian Moon 12/07/2005 08:18AM
possible_keys exist but key is NULL   6,618 David McLaughlin 02/22/2006 11:29AM
Re: possible_keys exist but key is NULL   3,404 Thomas CORBIERE 02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY   1,954 Robert Bergs 02/21/2006 07:00AM
what is sql.exe doing?   2,890 Zilan Ciftci 02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN   1,579 Odimar Tomazeli 02/17/2006 01:37PM
Subquery performance improvements: When?   4,171 Olaf van der Spek 02/08/2006 10:07AM
Re: Subquery performance improvements: When?   2,019 Olaf van der Spek 02/14/2006 08:31AM
Re: Subquery performance improvements: When?   2,041 Robin Schumacher 02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24   2,143 Robert van Twillert 02/13/2006 12:47PM
SUBQUERY PROBLEM   2,413 Odimar Tomazeli 02/07/2006 04:21PM
Re: SUBQUERY PROBLEM   1,608 Odimar Tomazeli 02/13/2006 12:16PM
Re: SUBQUERY PROBLEM   1,697 Odimar Tomazeli 02/13/2006 11:17AM
Re: SUBQUERY PROBLEM   1,676 Jay Pipes 02/13/2006 11:22AM
Re: SUBQUERY PROBLEM   1,812 Odimar Tomazeli 02/13/2006 11:06AM
Re: SUBQUERY PROBLEM   1,643 Odimar Tomazeli 02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team   1,669 Odimar Tomazeli 02/08/2006 10:26AM
Re: SUBQUERY PROBLEM   1,695 Robin Schumacher 02/08/2006 04:57AM
Re: SUBQUERY PROBLEM   1,597 Jay Pipes 02/08/2006 03:59PM
Re: SUBQUERY PROBLEM   1,722 Jay Pipes 02/07/2006 04:45PM
Re: SUBQUERY PROBLEM   1,614 Jay Pipes 02/07/2006 04:52PM
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.