MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/Python 2.2.2 m3 Development Release has been released 12/01/2016 10:48AM
MySQL Cluster Manager 1.4.1 has been released 11/24/2016 06:24AM
MySQL Router 2.0.4 has been released 11/23/2016 11:22AM
MySQL Connector/Node.js 1.0.5 m4 Development Release has been released 11/14/2016 08:41AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
EXISTS() optimization   18,668 Rob Blick 06/07/2006 10:00AM
Re: EXISTS() optimization   6,090 bill stamp 07/25/2006 07:54AM
Re: EXISTS() optimization   5,385 Nathan Cheng 07/25/2006 01:13PM
Re: EXISTS() optimization   4,892 Toa Sty 08/04/2006 04:45AM
Too many rows being read   2,440 preston 08/02/2006 02:02PM
Re: Too many rows being read   1,543 Bob Field 08/02/2006 02:18PM
Why does this query filesort?   2,356 Jim Daemon 07/27/2006 12:05PM
Re: Why does this query filesort?   1,560 KimSeong Loh 08/01/2006 11:14PM
optimize dynamic sql   2,759 Bhupesh Tripathi 07/28/2006 03:33AM
query of tables with a longblob   2,109 paul obyrne 06/23/2006 11:44AM
Re: query of tables with a longblob   1,478 Nathan Cheng 07/25/2006 01:26PM
Optimizing (a=b and c=d) OR (e=f and g=h)   2,196 a.h.s. boy 07/20/2006 12:07PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)   1,487 KimSeong Loh 07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)   1,484 a.h.s. boy 07/20/2006 10:09PM
With vs Without Primary Key in a particular case   6,334 Martin Feng 07/19/2006 11:02PM
Re: With vs Without Primary Key in a particular case   2,547 KimSeong Loh 07/20/2006 05:35PM
SELECT DISTINCT vs UNIQUE KEY   8,806 Martin Feng 07/19/2006 06:11AM
LEFT JOIN problem   2,825 Steve Jordi 07/17/2006 07:13AM
Re: LEFT JOIN problem   1,574 Peter Brawley 07/17/2006 08:07AM
Re: LEFT JOIN problem   1,549 Steve Jordi 07/17/2006 09:30AM
Re: LEFT JOIN problem   1,575 Peter Brawley 07/17/2006 12:03PM
Re: LEFT JOIN problem   1,505 Steve Jordi 07/17/2006 10:23PM
(How) are subqueries optimized involving the same table?   2,232 Jakobus Dornier 07/13/2006 08:02AM
Re: (How) are subqueries optimized involving the same table?   1,608 Jakobus Dornier 07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?   1,578 Bob Field 07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?   1,686 Jakobus Dornier 07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?   1,559 Bob Field 07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?   1,464 Jakobus Dornier 07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?   1,633 Bob Field 07/13/2006 08:12AM
How to get some documents or articles on the query optimization of MySQL????   2,084 Hui Sun 07/10/2006 07:10AM
Re: How to get some documents or articles on the query optimization of MySQL????   1,525 KimSeong Loh 07/10/2006 05:12PM
min() vs limit optimization   4,736 Paul Medynski 07/02/2006 05:34PM
Re: min() vs limit optimization   1,881 Apachez 07/02/2006 08:26PM
Re: min() vs limit optimization   1,854 Paul Medynski 07/03/2006 05:22PM
Re: min() vs limit optimization   1,950 Apachez 07/04/2006 06:51AM
Slow Union Query Opimization. Need help.   5,403 Roland Meier 06/29/2006 12:50AM
Re: Slow Union Query Opimization. Need help.   2,271 Jay Pipes 06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.   2,537 Roland Meier 06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.   2,762 Anthony Willard 06/29/2006 08:24AM
querying time is too high   2,440 trinath somanchi 06/27/2006 07:31AM
Re: querying time is too high   1,590 Anthony Willard 06/29/2006 08:52AM
Re: querying time is too high   1,572 trinath somanchi 06/29/2006 12:48AM
Re: querying time is too high   1,652 Jim Daemon 06/28/2006 10:00AM
Boolean search and 99% cpu   2,004 Taiyo Rai 06/27/2006 07:17AM
Joining several multi-to-multi tables   2,953 adambrill1986 06/20/2006 11:59AM
Re: Joining several multi-to-multi tables   1,777 adambrill1986 06/23/2006 06:58AM
Re: Joining several multi-to-multi tables   1,627 adambrill1986 06/20/2006 12:21PM
Re: Joining several multi-to-multi tables   1,647 adambrill1986 06/20/2006 01:44PM
Re: Joining several multi-to-multi tables   1,570 Bill Karwin 06/20/2006 04:23PM
Re: Joining several multi-to-multi tables   1,573 KimSeong Loh 06/20/2006 06:02PM
Re: Joining several multi-to-multi tables   1,581 Bill Karwin 06/20/2006 01:02PM
Re: Joining several multi-to-multi tables   1,593 Bill Karwin 06/20/2006 12:14PM
no optimization?   2,031 Uwe 05/22/2006 05:47AM
Re: no optimization?   1,626 Apachez 06/18/2006 08:50PM
Re: no optimization?   1,563 Uwe 06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,143 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,516 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,815 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,796 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,850 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,299 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,790 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,687 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,746 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,665 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,724 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,708 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,684 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,815 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,671 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   5,025 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,941 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   3,004 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,497 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,946 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,832 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,528 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,819 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,481 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,243 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,146 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,107 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,332 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,895 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,977 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,604 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,179 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   6,099 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,328 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,657 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,106 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,706 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,677 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,072 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,564 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,689 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,519 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,936 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,317 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,566 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,473 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,361 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,353 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,147 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,509 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,837 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,329 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,055 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,073 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,189 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,342 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,526 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,661 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,865 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,235 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,053 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,878 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,934 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,087 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,138 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,541 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,572 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,918 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,232 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,588 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,610 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   2,025 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,609 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,396 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,061 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,127 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,924 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,786 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   21,651 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,648 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,184 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,847 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,875 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,147 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,949 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,368 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,071 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,971 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,774 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,876 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   2,033 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   2,000 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,813 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,990 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,246 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,386 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,596 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,238 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,271 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,838 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,908 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,624 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,671 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,636 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,705 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,661 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,925 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,628 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,185 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,468 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,041 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,772 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,491 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   3,039 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,208 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,286 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,241 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,950 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   16,262 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,613 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,227 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,610 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,243 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,645 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,068 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,530 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,578 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,810 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,360 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,345 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   2,089 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,518 Apachez 04/21/2006 04:26AM
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.