Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/Python 2.0.0 Alpha has been released 07/24/2014 11:56AM
MySQL Connector/NET 6.9.2 RC has been released 07/18/2014 07:41PM
MySQL Connector/ODBC 5.3.4 has been released 07/18/2014 05:49PM
MySQL Enterprise Monitor 3.0.13 has been released 07/18/2014 03:20PM
MySQL Cluster 7.1.32 has been released 07/15/2014 09:06PM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
Subject Views Written By Posted
Optimizer not working adequately   1,738 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,394 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,415 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,000 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,001 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   1,934 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   1,837 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,367 Apachez 04/21/2006 04:26AM
where condition optimization   2,100 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,430 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,455 prasanna 04/19/2006 02:26AM
Database structure question   1,842 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,424 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,408 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,805 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,265 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,480 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,452 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,523 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,467 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,560 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,517 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,479 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,749 Stuart Brooks 04/07/2006 06:56AM
data design optimization   1,951 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,549 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,415 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,458 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,446 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,496 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,667 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,457 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,783 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   1,963 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,491 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,812 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,859 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,171 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,623 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,625 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,636 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,510 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,514 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,425 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,459 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,400 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   1,863 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,660 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,579 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,446 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   2,714 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,812 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,730 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,452 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,712 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,680 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,758 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,582 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,608 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,572 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,076 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,572 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,533 03/24/2006 11:02AM
Query Optimization   1,920 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,475 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,402 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,512 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,054 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,696 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,086 Tobias Marx 03/20/2006 05:26PM
Query   1,785 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,491 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,429 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,457 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,298 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,502 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   29,652 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,597 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,322 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,466 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   16,940 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   18,765 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,429 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   2,638 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,628 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,504 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,601 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,626 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,592 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,671 Apachez 03/01/2006 03:25PM
is HASH index being ignored   2,343 Michal Carson 03/07/2006 10:17PM
Re: is HASH index being ignored   1,567 Michal Carson 03/08/2006 10:59AM
Re: is HASH index being ignored   1,644 Felix Geerinckx 03/08/2006 04:32AM
Re: is HASH index being ignored   1,519 KimSeong Loh 03/08/2006 07:50PM
Urgent Optimized QUERY needed::   2,187 Mohammed Abdullah All Marbin 03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::   1,497 Bob Field 03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour   3,220 Victor Perez Roche 02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,589 Edwin DeSouza 02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,504 Victor Perez Roche 02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,555 Edwin DeSouza 03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,568 Victor Perez Roche 02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,557 Olaf van der Spek 02/20/2006 09:20AM
Range query performance question   4,958 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,119 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   25,533 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   11,131 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   2,104 Solon Barns 02/22/2006 12:52PM
Re: Need recommendation regarding IN expression   1,558 Jay Pipes 02/22/2006 01:29PM
Re: Need recommendation regarding IN expression   1,339 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,532 Jay Pipes 02/23/2006 10:55AM
slow subquery   4,724 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,595 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   2,046 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,081 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,143 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,792 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,094 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,248 Brian Moon 12/07/2005 08:18AM
possible_keys exist but key is NULL   6,341 David McLaughlin 02/22/2006 11:29AM
Re: possible_keys exist but key is NULL   3,351 Thomas CORBIERE 02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY   1,853 Robert Bergs 02/21/2006 07:00AM
what is sql.exe doing?   2,751 Zilan Ciftci 02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN   1,492 Odimar Tomazeli 02/17/2006 01:37PM
Subquery performance improvements: When?   4,002 Olaf van der Spek 02/08/2006 10:07AM
Re: Subquery performance improvements: When?   1,972 Olaf van der Spek 02/14/2006 08:31AM
Re: Subquery performance improvements: When?   1,995 Robin Schumacher 02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24   2,062 Robert van Twillert 02/13/2006 12:47PM
SUBQUERY PROBLEM   2,247 Odimar Tomazeli 02/07/2006 04:21PM
Re: SUBQUERY PROBLEM   1,525 Odimar Tomazeli 02/13/2006 12:16PM
Re: SUBQUERY PROBLEM   1,616 Odimar Tomazeli 02/13/2006 11:17AM
Re: SUBQUERY PROBLEM   1,610 Jay Pipes 02/13/2006 11:22AM
Re: SUBQUERY PROBLEM   1,731 Odimar Tomazeli 02/13/2006 11:06AM
Re: SUBQUERY PROBLEM   1,546 Odimar Tomazeli 02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team   1,566 Odimar Tomazeli 02/08/2006 10:26AM
Re: SUBQUERY PROBLEM   1,632 Robin Schumacher 02/08/2006 04:57AM
Re: SUBQUERY PROBLEM   1,532 Jay Pipes 02/08/2006 03:59PM
Re: SUBQUERY PROBLEM   1,670 Jay Pipes 02/07/2006 04:45PM
Re: SUBQUERY PROBLEM   1,535 Jay Pipes 02/07/2006 04:52PM
Subqueries too slow   4,232 Andreas Schlicker 02/06/2006 11:08AM
Re: Subqueries too slow   1,752 Andreas Schlicker 02/10/2006 09:49AM
Re: Subqueries too slow   1,784 Jay Pipes 02/10/2006 10:43AM
Re: Subqueries too slow   1,742 Andreas Schlicker 02/10/2006 03:18AM
Re: Subqueries too slow   1,698 Jay Pipes 02/10/2006 08:51AM
Re: Subqueries too slow   1,960 Andreas Schlicker 02/07/2006 08:38AM
Re: Subqueries too slow   1,958 Robin Schumacher 02/06/2006 02:17PM
Re: Subqueries too slow   1,879 Andreas Schlicker 02/07/2006 07:06AM
Re: Subqueries too slow   2,107 Jay Pipes 02/06/2006 11:54AM
Is this query optimized?   1,790 zaw sze 02/09/2006 09:44PM
Question about Handler_write   2,447 Sebastien Caisse 02/09/2006 09:42AM
clash between unique and index keys   4,152 Kenneth Vogt 02/08/2006 12:58AM
Re: clash between unique and index keys   2,059 Kenneth Vogt 02/09/2006 12:04AM
Re: clash between unique and index keys   2,167 Jay Pipes 02/08/2006 04:40PM
Re: clash between unique and index keys   2,031 Kenneth Vogt 02/08/2006 05:44PM
Re: clash between unique and index keys   2,084 Jay Pipes 02/08/2006 05:49PM
qcache_free_blocks   7,128 Jacky Shu 02/07/2006 08:13AM
Re: qcache_free_blocks   4,071 Jay Pipes 02/07/2006 10:10AM
Re: qcache_free_blocks   3,621 Jacky Shu 02/07/2006 12:13PM
optimize   2,259 edson fernando 01/17/2006 02:41PM
Re: optimize   1,611 Sebastien Caisse 02/02/2006 09:02AM
Re: optimize   1,614 edson fernando 01/18/2006 09:07AM
Re: optimize   1,607 KimSeong Loh 01/17/2006 06:48PM
Double Index Performance   7,003 Jawad Laraqui 01/12/2006 02:21PM
Re: Double Index Performance   2,133 Sebastien Caisse 01/16/2006 06:24AM
Re: Double Index Performance   2,288 01/16/2006 08:46AM
Re: Double Index Performance   2,054 Sebastien Caisse 01/17/2006 06:45AM
Re: Double Index Performance   2,192 Sebastien Caisse 02/01/2006 01:05PM
Re: Double Index Performance   2,665 01/13/2006 05:18PM
'where' with 'in' doesn't use index?   2,259 Vlado Kurelec 01/24/2006 05:25AM
Re: 'where' with 'in' doesn't use index?   1,650 Vlado Kurelec 02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?   1,639 Robin Schumacher 01/30/2006 04:45PM
subquery breaks optimization   2,031 Kiryll Mirnenko 01/20/2006 06:51AM
Re: subquery breaks optimization   1,629 Robin Schumacher 01/24/2006 07:14PM
mysql dont use my Index?   2,040 Johannes Fosseus 01/12/2006 08:22AM
Re: mysql dont use my Index?   1,602 Jay Pipes 01/18/2006 10:36PM
does Select values effect index selection?   2,237 ade br 01/10/2006 09:30AM
Re: does Select values effect index selection?   1,644 Jay Pipes 01/10/2006 05:04PM
Optimizing with DATE()   2,102 Paul Hartman 01/03/2006 02:28PM
Re: Optimizing with DATE()   1,603 KimSeong Loh 01/03/2006 06:53PM
Simple Query - but explain worries me   2,258 Jake Day 11/01/2005 01:26AM
Re: Simple Query - but explain worries me   1,652 Jake Day 11/01/2005 02:48AM
Re: Simple Query - but explain worries me   1,634 Konstantin Osipov 01/02/2006 05:22PM
Re: Simple Query - but explain worries me   1,675 Vangelis Katsikaros 11/01/2005 03:05AM
Re: Simple Query - but explain worries me   1,643 Jake Day 11/01/2005 05:13AM
Re: Simple Query - but explain worries me   1,637 Vangelis Katsikaros 11/01/2005 05:57AM
Re: Simple Query - but explain worries me   1,607 Jake Day 11/01/2005 07:37AM
Re: Simple Query - but explain worries me   1,668 Jake Day 11/01/2005 08:03AM
select distinct slower in 5.0 than 4.1   2,354 Saar Barhoom 12/18/2005 12:24PM
Re: select distinct slower in 5.0 than 4.1   1,705 KimSeong Loh 12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1   1,692 Peter Zaitsev 12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1   1,717 Saar Barhoom 12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1   1,688 Timour Katchaounov 12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1   1,980 Jay Pipes 12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1   1,744 Saar Barhoom 12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1   1,695 Jay Pipes 12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1   1,698 Saar Barhoom 12/21/2005 01:54AM
Range Join Performance   3,148 Lionel Horn 11/23/2005 08:47AM
Re: Range Join Performance   1,773 Jay Pipes 12/26/2005 07:56PM
Re: Range Join Performance   1,774 Igor Babaev 12/21/2005 11:10PM
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.