Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL for Visual Studio 1.2.0 alpha has been released 04/21/2014 11:51AM
MySQL Enterprise Monitor 2.3.16 has been released 04/17/2014 11:45AM
MySQL Enterprise Monitor 3.0.9 has been released 04/14/2014 05:53PM
MySQL Cluster 7.2.16 has been released 04/09/2014 04:32AM
MySQL Cluster 7.3.5 has been released 04/07/2014 08:15PM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
Subject Views Written By Posted
High RAM usage   2,350 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,794 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,202 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,472 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,442 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,504 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,458 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,551 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,500 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,469 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,728 Stuart Brooks 04/07/2006 06:56AM
data design optimization   1,931 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,534 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,411 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,452 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,438 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,485 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,655 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,451 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,761 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   1,950 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,482 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,792 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,850 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,131 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,603 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,604 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,620 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,498 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,505 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,412 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,449 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,382 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   1,850 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,650 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,560 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,429 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   2,654 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,801 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,718 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,442 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,698 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,668 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,741 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,549 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,594 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,561 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,043 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,561 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,525 03/24/2006 11:02AM
Query Optimization   1,898 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,465 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,389 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,502 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,031 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,689 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,079 Tobias Marx 03/20/2006 05:26PM
Query   1,718 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,476 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,412 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,446 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,264 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,493 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   29,379 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,504 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,243 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,398 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   16,864 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   18,658 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,339 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   2,585 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,612 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,496 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,588 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,608 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,575 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,652 Apachez 03/01/2006 03:25PM
is HASH index being ignored   2,274 Michal Carson 03/07/2006 10:17PM
Re: is HASH index being ignored   1,547 Michal Carson 03/08/2006 10:59AM
Re: is HASH index being ignored   1,630 Felix Geerinckx 03/08/2006 04:32AM
Re: is HASH index being ignored   1,507 KimSeong Loh 03/08/2006 07:50PM
Urgent Optimized QUERY needed::   2,138 Mohammed Abdullah All Marbin 03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::   1,487 Bob Field 03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour   3,176 Victor Perez Roche 02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,564 Edwin DeSouza 02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,491 Victor Perez Roche 02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,545 Edwin DeSouza 03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,550 Victor Perez Roche 02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour   1,545 Olaf van der Spek 02/20/2006 09:20AM
Range query performance question   4,879 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,106 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   25,206 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   11,033 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   2,072 Solon Barns 02/22/2006 12:52PM
Re: Need recommendation regarding IN expression   1,549 Jay Pipes 02/22/2006 01:29PM
Re: Need recommendation regarding IN expression   1,320 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,521 Jay Pipes 02/23/2006 10:55AM
slow subquery   4,666 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,573 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   2,033 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,065 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,128 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,776 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,087 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,228 Brian Moon 12/07/2005 08:18AM
possible_keys exist but key is NULL   6,238 David McLaughlin 02/22/2006 11:29AM
Re: possible_keys exist but key is NULL   3,333 Thomas CORBIERE 02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY   1,835 Robert Bergs 02/21/2006 07:00AM
what is sql.exe doing?   2,712 Zilan Ciftci 02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN   1,462 Odimar Tomazeli 02/17/2006 01:37PM
Subquery performance improvements: When?   3,951 Olaf van der Spek 02/08/2006 10:07AM
Re: Subquery performance improvements: When?   1,959 Olaf van der Spek 02/14/2006 08:31AM
Re: Subquery performance improvements: When?   1,986 Robin Schumacher 02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24   2,043 Robert van Twillert 02/13/2006 12:47PM
SUBQUERY PROBLEM   2,222 Odimar Tomazeli 02/07/2006 04:21PM
Re: SUBQUERY PROBLEM   1,516 Odimar Tomazeli 02/13/2006 12:16PM
Re: SUBQUERY PROBLEM   1,607 Odimar Tomazeli 02/13/2006 11:17AM
Re: SUBQUERY PROBLEM   1,597 Jay Pipes 02/13/2006 11:22AM
Re: SUBQUERY PROBLEM   1,720 Odimar Tomazeli 02/13/2006 11:06AM
Re: SUBQUERY PROBLEM   1,537 Odimar Tomazeli 02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team   1,555 Odimar Tomazeli 02/08/2006 10:26AM
Re: SUBQUERY PROBLEM   1,628 Robin Schumacher 02/08/2006 04:57AM
Re: SUBQUERY PROBLEM   1,520 Jay Pipes 02/08/2006 03:59PM
Re: SUBQUERY PROBLEM   1,664 Jay Pipes 02/07/2006 04:45PM
Re: SUBQUERY PROBLEM   1,529 Jay Pipes 02/07/2006 04:52PM
Subqueries too slow   4,195 Andreas Schlicker 02/06/2006 11:08AM
Re: Subqueries too slow   1,739 Andreas Schlicker 02/10/2006 09:49AM
Re: Subqueries too slow   1,757 Jay Pipes 02/10/2006 10:43AM
Re: Subqueries too slow   1,726 Andreas Schlicker 02/10/2006 03:18AM
Re: Subqueries too slow   1,687 Jay Pipes 02/10/2006 08:51AM
Re: Subqueries too slow   1,944 Andreas Schlicker 02/07/2006 08:38AM
Re: Subqueries too slow   1,948 Robin Schumacher 02/06/2006 02:17PM
Re: Subqueries too slow   1,857 Andreas Schlicker 02/07/2006 07:06AM
Re: Subqueries too slow   2,091 Jay Pipes 02/06/2006 11:54AM
Is this query optimized?   1,774 zaw sze 02/09/2006 09:44PM
Question about Handler_write   2,420 Sebastien Caisse 02/09/2006 09:42AM
clash between unique and index keys   4,071 Kenneth Vogt 02/08/2006 12:58AM
Re: clash between unique and index keys   2,052 Kenneth Vogt 02/09/2006 12:04AM
Re: clash between unique and index keys   2,161 Jay Pipes 02/08/2006 04:40PM
Re: clash between unique and index keys   2,021 Kenneth Vogt 02/08/2006 05:44PM
Re: clash between unique and index keys   2,078 Jay Pipes 02/08/2006 05:49PM
qcache_free_blocks   7,062 Jacky Shu 02/07/2006 08:13AM
Re: qcache_free_blocks   4,026 Jay Pipes 02/07/2006 10:10AM
Re: qcache_free_blocks   3,604 Jacky Shu 02/07/2006 12:13PM
optimize   2,238 edson fernando 01/17/2006 02:41PM
Re: optimize   1,605 Sebastien Caisse 02/02/2006 09:02AM
Re: optimize   1,608 edson fernando 01/18/2006 09:07AM
Re: optimize   1,594 KimSeong Loh 01/17/2006 06:48PM
Double Index Performance   6,946 Jawad Laraqui 01/12/2006 02:21PM
Re: Double Index Performance   2,113 Sebastien Caisse 01/16/2006 06:24AM
Re: Double Index Performance   2,270 01/16/2006 08:46AM
Re: Double Index Performance   2,046 Sebastien Caisse 01/17/2006 06:45AM
Re: Double Index Performance   2,178 Sebastien Caisse 02/01/2006 01:05PM
Re: Double Index Performance   2,645 01/13/2006 05:18PM
'where' with 'in' doesn't use index?   2,234 Vlado Kurelec 01/24/2006 05:25AM
Re: 'where' with 'in' doesn't use index?   1,639 Vlado Kurelec 02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?   1,629 Robin Schumacher 01/30/2006 04:45PM
subquery breaks optimization   2,016 Kiryll Mirnenko 01/20/2006 06:51AM
Re: subquery breaks optimization   1,618 Robin Schumacher 01/24/2006 07:14PM
mysql dont use my Index?   2,015 Johannes Fosseus 01/12/2006 08:22AM
Re: mysql dont use my Index?   1,595 Jay Pipes 01/18/2006 10:36PM
does Select values effect index selection?   2,213 ade br 01/10/2006 09:30AM
Re: does Select values effect index selection?   1,636 Jay Pipes 01/10/2006 05:04PM
Optimizing with DATE()   2,077 Paul Hartman 01/03/2006 02:28PM
Re: Optimizing with DATE()   1,599 KimSeong Loh 01/03/2006 06:53PM
Simple Query - but explain worries me   2,220 Jake Day 11/01/2005 01:26AM
Re: Simple Query - but explain worries me   1,642 Jake Day 11/01/2005 02:48AM
Re: Simple Query - but explain worries me   1,621 Konstantin Osipov 01/02/2006 05:22PM
Re: Simple Query - but explain worries me   1,659 Vangelis Katsikaros 11/01/2005 03:05AM
Re: Simple Query - but explain worries me   1,630 Jake Day 11/01/2005 05:13AM
Re: Simple Query - but explain worries me   1,621 Vangelis Katsikaros 11/01/2005 05:57AM
Re: Simple Query - but explain worries me   1,602 Jake Day 11/01/2005 07:37AM
Re: Simple Query - but explain worries me   1,655 Jake Day 11/01/2005 08:03AM
select distinct slower in 5.0 than 4.1   2,322 Saar Barhoom 12/18/2005 12:24PM
Re: select distinct slower in 5.0 than 4.1   1,686 KimSeong Loh 12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1   1,680 Peter Zaitsev 12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1   1,694 Saar Barhoom 12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1   1,678 Timour Katchaounov 12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1   1,959 Jay Pipes 12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1   1,730 Saar Barhoom 12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1   1,678 Jay Pipes 12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1   1,690 Saar Barhoom 12/21/2005 01:54AM
Range Join Performance   3,109 Lionel Horn 11/23/2005 08:47AM
Re: Range Join Performance   1,760 Jay Pipes 12/26/2005 07:56PM
Re: Range Join Performance   1,765 Igor Babaev 12/21/2005 11:10PM
does my index take effect?   2,138 zhenxing zhai 12/21/2005 03:19AM
Re: does my index take effect?   1,587 Igor Babaev 12/21/2005 11:03PM
Index merge optimization with joined tables?   2,626 Kayra Otaner 12/01/2005 11:39AM
Re: Index merge optimization with joined tables?   1,672 Igor Babaev 12/21/2005 10:54PM
Re: Index merge optimization with joined tables?   1,732 Brian Moon 12/07/2005 08:21AM
Re: Index merge optimization with joined tables?   1,739 Jay Pipes 12/07/2005 05:37PM
explain + straight join oddity   7,236 Stuart Maclean 12/20/2005 08:06PM
Re: explain + straight join oddity   2,204 Igor Babaev 12/21/2005 10:44PM
Can't get my indexes right   2,403 Tobias Ritzau 11/26/2005 04:53PM
Re: Can't get my indexes right   1,714 Igor Babaev 12/21/2005 10:34PM
Re: Can't get my indexes right   1,701 Tobias Ritzau 11/28/2005 02:19PM
Re: Can't get my indexes right   1,607 Tobias Ritzau 11/28/2005 07:40AM
Re: Can't get my indexes right   1,754 KimSeong Loh 11/28/2005 03:17AM
Re: Can't get my indexes right   1,665 Tobias Ritzau 11/28/2005 02:44AM
Re: Can't get my indexes right   1,698 KimSeong Loh 11/27/2005 07:28PM
optimization of left outer joins   3,465 Clive Cox 12/16/2005 09:25AM
Re: optimization of left outer joins   1,803 Igor Babaev 12/19/2005 11:42PM
Re: optimization of left outer joins   2,028 Jay Pipes 12/16/2005 10:23AM
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.