MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.3 GA has been released 09/15/2016 03:06PM
MySQL Connector/Python 2.2.1 m2 Development Release has been released 09/13/2016 09:58AM
Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 has been released 09/12/2016 02:59PM
MySQL Community Server 8.0.0-dmr has been released (part 3/3) 09/12/2016 08:52AM
MySQL Community Server 8.0.0-dmr has been released (part 2/3) 09/12/2016 08:50AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
LEFT JOIN problem   2,792 Steve Jordi 07/17/2006 07:13AM
Re: LEFT JOIN problem   1,568 Peter Brawley 07/17/2006 08:07AM
Re: LEFT JOIN problem   1,545 Steve Jordi 07/17/2006 09:30AM
Re: LEFT JOIN problem   1,570 Peter Brawley 07/17/2006 12:03PM
Re: LEFT JOIN problem   1,501 Steve Jordi 07/17/2006 10:23PM
(How) are subqueries optimized involving the same table?   2,217 Jakobus Dornier 07/13/2006 08:02AM
Re: (How) are subqueries optimized involving the same table?   1,603 Jakobus Dornier 07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?   1,572 Bob Field 07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?   1,679 Jakobus Dornier 07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?   1,555 Bob Field 07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?   1,461 Jakobus Dornier 07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?   1,628 Bob Field 07/13/2006 08:12AM
How to get some documents or articles on the query optimization of MySQL????   2,068 Hui Sun 07/10/2006 07:10AM
Re: How to get some documents or articles on the query optimization of MySQL????   1,516 KimSeong Loh 07/10/2006 05:12PM
min() vs limit optimization   4,719 Paul Medynski 07/02/2006 05:34PM
Re: min() vs limit optimization   1,876 Apachez 07/02/2006 08:26PM
Re: min() vs limit optimization   1,846 Paul Medynski 07/03/2006 05:22PM
Re: min() vs limit optimization   1,944 Apachez 07/04/2006 06:51AM
Slow Union Query Opimization. Need help.   5,369 Roland Meier 06/29/2006 12:50AM
Re: Slow Union Query Opimization. Need help.   2,258 Jay Pipes 06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.   2,503 Roland Meier 06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.   2,747 Anthony Willard 06/29/2006 08:24AM
querying time is too high   2,426 trinath somanchi 06/27/2006 07:31AM
Re: querying time is too high   1,581 Anthony Willard 06/29/2006 08:52AM
Re: querying time is too high   1,561 trinath somanchi 06/29/2006 12:48AM
Re: querying time is too high   1,641 Jim Daemon 06/28/2006 10:00AM
Boolean search and 99% cpu   1,987 Taiyo Rai 06/27/2006 07:17AM
Joining several multi-to-multi tables   2,903 adambrill1986 06/20/2006 11:59AM
Re: Joining several multi-to-multi tables   1,770 adambrill1986 06/23/2006 06:58AM
Re: Joining several multi-to-multi tables   1,621 adambrill1986 06/20/2006 12:21PM
Re: Joining several multi-to-multi tables   1,638 adambrill1986 06/20/2006 01:44PM
Re: Joining several multi-to-multi tables   1,561 Bill Karwin 06/20/2006 04:23PM
Re: Joining several multi-to-multi tables   1,562 KimSeong Loh 06/20/2006 06:02PM
Re: Joining several multi-to-multi tables   1,573 Bill Karwin 06/20/2006 01:02PM
Re: Joining several multi-to-multi tables   1,583 Bill Karwin 06/20/2006 12:14PM
no optimization?   2,016 Uwe 05/22/2006 05:47AM
Re: no optimization?   1,621 Apachez 06/18/2006 08:50PM
Re: no optimization?   1,552 Uwe 06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,129 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,500 William Shubert 06/21/2006 12:36AM
RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min   3,772 Ijaz Rashid 06/20/2006 07:06AM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min   1,787 Bill Karwin 06/20/2006 12:18PM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min   1,833 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,249 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,780 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,680 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,716 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,652 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,711 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,700 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,675 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,800 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,657 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   4,989 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,929 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   2,990 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,486 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,921 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,826 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,516 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,809 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,461 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,230 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,132 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,087 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,315 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,886 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,911 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,577 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,162 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   6,060 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,317 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,544 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,087 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,678 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,668 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,054 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,547 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,678 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,480 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,892 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,306 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,531 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,453 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,350 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,341 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,135 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,498 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,819 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,311 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,043 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,062 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,164 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,334 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,521 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,649 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,829 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,224 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,041 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,869 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,925 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,074 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,120 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,533 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,566 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,908 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,201 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,575 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,601 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   2,014 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,588 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,371 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,052 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,117 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,910 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,777 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   21,481 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,622 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,151 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,804 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,847 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,133 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,939 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,342 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,057 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,964 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,749 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,861 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   2,013 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,989 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,783 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,957 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,231 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,360 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,577 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,229 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,236 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,827 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,877 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,613 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,659 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,626 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,696 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,652 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,898 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,618 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,171 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,456 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,031 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,583 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,430 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   3,007 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,173 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,234 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,197 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,910 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   16,053 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,553 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,206 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,599 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,228 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,636 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,057 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,523 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,571 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,722 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,326 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,296 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   2,068 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,510 Apachez 04/21/2006 04:26AM
where condition optimization   2,464 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,555 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,584 prasanna 04/19/2006 02:26AM
Database structure question   2,140 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,557 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,988 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,983 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,872 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,573 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,585 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,661 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,623 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,722 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,675 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,614 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   2,039 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,296 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,726 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,579 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,602 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,589 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,692 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,916 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,574 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   2,083 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,239 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,622 Ulrich Schmid 03/28/2006 04:01AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17

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.