MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/J 6.0.3 m2 Development Release has been released 06/24/2016 02:34PM
MySQL Shell 1.0.4 m2 Development Release has been released 06/23/2016 05:22AM
MySQL Connector/Node.js 1.0.3 m2 Development Release has been released 06/21/2016 02:47PM
MySQL Connector/NET 7.0.3 m2 development has been released 06/20/2016 12:33PM
MySQL Workbench 6.3.7 GA has been released 06/13/2016 11:36AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
no optimization?   1,983 Uwe 05/22/2006 05:47AM
Re: no optimization?   1,607 Apachez 06/18/2006 08:50PM
Re: no optimization?   1,532 Uwe 06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,096 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,486 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,697 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,771 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,811 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,171 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,770 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,672 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,685 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,637 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,695 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,684 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,660 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,779 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,646 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   4,928 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,916 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   2,974 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,476 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,876 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,816 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,507 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,797 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,430 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,217 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,115 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,066 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,278 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,877 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,782 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,524 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,137 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   6,010 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,293 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,348 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,054 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,642 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,635 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,016 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,507 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,662 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,397 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,835 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,295 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,482 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,429 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,328 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,319 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,126 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,480 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,778 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,289 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,027 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,048 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,140 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,328 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,516 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,638 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,733 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,203 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,025 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,850 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,907 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,056 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,092 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,515 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,555 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,881 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,153 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,559 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,580 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,991 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,554 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,325 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,032 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,096 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,883 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,760 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   21,091 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,576 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,097 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,721 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,808 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,103 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,923 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,311 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,044 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,954 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,716 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,824 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,986 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,972 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,731 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,925 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,212 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,327 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,558 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,216 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,201 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,809 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,824 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,599 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,644 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,612 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,682 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,640 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,862 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,605 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,156 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,439 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,011 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,324 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,328 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,965 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,128 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,179 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,145 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,862 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   15,780 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,423 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,181 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,587 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,216 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,618 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,031 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,511 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,553 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,609 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,276 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,229 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   2,042 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,495 Apachez 04/21/2006 04:26AM
where condition optimization   2,448 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,547 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,572 prasanna 04/19/2006 02:26AM
Database structure question   2,103 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,543 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,931 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,967 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,798 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,569 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,645 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,608 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,710 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,657 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,598 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   2,010 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,267 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,712 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,566 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,588 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,576 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,679 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,888 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,567 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   2,048 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,201 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,608 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   2,029 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,997 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,614 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,797 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,804 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,823 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,681 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,683 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,600 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,631 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,562 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   2,042 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,855 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,745 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,618 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,152 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,967 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,927 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,600 Björn Steinbrink 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,934 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,839 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,926 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   4,038 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,804 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,774 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,382 Björn Steinbrink 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,739 Björn Steinbrink 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,690 Björn Steinbrink 03/24/2006 11:02AM
Query Optimization   2,224 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,568 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,505 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,623 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,333 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,802 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,202 Tobias Marx 03/20/2006 05:26PM
Query   2,143 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,633 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,583 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,565 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,603 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,615 Ilan Goldman 03/10/2006 04:19PM
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.