MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.27 has been released 08/22/2016 12:00PM
MySQL Connector/NET 7.0.4 m3 development has been released 08/22/2016 08:36AM
MySQL Utilities 1.6.4 GA has been released 08/05/2016 10:44AM
MySQL Enterprise Backup 4.0.3 has been released 08/05/2016 09:28AM
MySQL Notifier 1.1.7 has been released 08/01/2016 04:37PM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
querying time is too high   2,415 trinath somanchi 06/27/2006 07:31AM
Re: querying time is too high   1,575 Anthony Willard 06/29/2006 08:52AM
Re: querying time is too high   1,553 trinath somanchi 06/29/2006 12:48AM
Re: querying time is too high   1,632 Jim Daemon 06/28/2006 10:00AM
Boolean search and 99% cpu   1,975 Taiyo Rai 06/27/2006 07:17AM
Joining several multi-to-multi tables   2,871 adambrill1986 06/20/2006 11:59AM
Re: Joining several multi-to-multi tables   1,765 adambrill1986 06/23/2006 06:58AM
Re: Joining several multi-to-multi tables   1,614 adambrill1986 06/20/2006 12:21PM
Re: Joining several multi-to-multi tables   1,630 adambrill1986 06/20/2006 01:44PM
Re: Joining several multi-to-multi tables   1,551 Bill Karwin 06/20/2006 04:23PM
Re: Joining several multi-to-multi tables   1,555 KimSeong Loh 06/20/2006 06:02PM
Re: Joining several multi-to-multi tables   1,563 Bill Karwin 06/20/2006 01:02PM
Re: Joining several multi-to-multi tables   1,570 Bill Karwin 06/20/2006 12:14PM
no optimization?   1,999 Uwe 05/22/2006 05:47AM
Re: no optimization?   1,616 Apachez 06/18/2006 08:50PM
Re: no optimization?   1,544 Uwe 06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,109 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,493 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,745 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,779 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,822 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,214 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,773 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,676 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,698 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,646 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,703 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,694 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,668 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,789 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,654 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   4,971 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,923 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   2,982 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,482 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,903 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,821 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,512 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,804 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,445 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,225 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,124 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,075 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,300 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,880 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,855 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,543 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,148 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   6,040 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,307 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,469 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,072 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,661 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,650 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,034 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,528 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,669 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,450 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,868 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,298 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,512 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,438 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,344 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,332 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,130 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,489 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,803 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,303 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,037 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,055 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,154 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,330 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,520 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,644 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,789 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,219 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,034 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,863 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,915 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,067 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,107 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,528 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,562 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,892 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,177 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,566 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,588 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   2,004 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,574 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,357 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,041 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,106 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,893 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,767 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   21,337 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,600 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,128 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,769 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,824 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,116 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,933 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,323 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,053 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,959 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,733 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,846 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   2,001 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,981 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,760 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,943 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,222 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,345 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,569 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,225 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,216 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,818 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,855 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,608 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,651 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,619 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,689 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,646 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,882 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,614 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,165 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,448 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,020 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,494 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,398 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,995 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,162 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,215 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,177 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,892 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   15,937 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,501 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,195 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,594 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,223 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,630 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,040 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,517 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,561 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,667 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,297 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,267 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   2,056 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,504 Apachez 04/21/2006 04:26AM
where condition optimization   2,456 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,552 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,579 prasanna 04/19/2006 02:26AM
Database structure question   2,119 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,551 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,963 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,977 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,841 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,569 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,578 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,653 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,614 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,716 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,667 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,605 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   2,024 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,283 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,719 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,573 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,597 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,582 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,687 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,903 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,571 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   2,064 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,224 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,614 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   2,041 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   2,003 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,641 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,809 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,810 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,830 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,690 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,694 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,605 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,639 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,571 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   2,053 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,866 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,750 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,623 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,178 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,977 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,948 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,603 Björn Steinbrink 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,943 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,844 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,929 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   4,066 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,826 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,782 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,400 Björn Steinbrink 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,742 Björn Steinbrink 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,697 Björn Steinbrink 03/24/2006 11:02AM
Query Optimization   2,240 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,571 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,511 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,626 Peter Brawley 03/21/2006 11:24AM
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.