MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.2.6 has been released 01/20/2017 01:41PM
MySQL Enterprise Monitor 3.1.6 has been released 01/20/2017 12:39PM
MySQL Cluster 7.5.5 has been released 01/17/2017 02:22PM
MySQL Cluster 7.2.27 has been released 01/17/2017 11:04AM
MySQL Cluster 7.3.16 has been released 01/17/2017 10:56AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
How to create on-the-fly index on derived table?   9,711 Nathan Cheng 07/25/2006 01:05PM
Re: How to create on-the-fly index on derived table?   5,405 Nathan Cheng 08/12/2006 03:04PM
difference performance of simple SELECT (on large tables) between MySql running on Windows XP and on Ubuntu   2,363 Ed Stone 08/09/2006 03:48PM
EXISTS() optimization   18,710 Rob Blick 06/07/2006 10:00AM
Re: EXISTS() optimization   6,111 bill stamp 07/25/2006 07:54AM
Re: EXISTS() optimization   5,394 Nathan Cheng 07/25/2006 01:13PM
Re: EXISTS() optimization   4,901 Toa Sty 08/04/2006 04:45AM
Too many rows being read   2,459 preston 08/02/2006 02:02PM
Re: Too many rows being read   1,551 Bob Field 08/02/2006 02:18PM
Why does this query filesort?   2,373 Jim Daemon 07/27/2006 12:05PM
Re: Why does this query filesort?   1,569 KimSeong Loh 08/01/2006 11:14PM
optimize dynamic sql   2,797 Bhupesh Tripathi 07/28/2006 03:33AM
query of tables with a longblob   2,137 paul obyrne 06/23/2006 11:44AM
Re: query of tables with a longblob   1,489 Nathan Cheng 07/25/2006 01:26PM
Optimizing (a=b and c=d) OR (e=f and g=h)   2,210 a.h.s. boy 07/20/2006 12:07PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)   1,496 KimSeong Loh 07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)   1,491 a.h.s. boy 07/20/2006 10:09PM
With vs Without Primary Key in a particular case   6,363 Martin Feng 07/19/2006 11:02PM
Re: With vs Without Primary Key in a particular case   2,563 KimSeong Loh 07/20/2006 05:35PM
SELECT DISTINCT vs UNIQUE KEY   8,850 Martin Feng 07/19/2006 06:11AM
LEFT JOIN problem   2,849 Steve Jordi 07/17/2006 07:13AM
Re: LEFT JOIN problem   1,584 Peter Brawley 07/17/2006 08:07AM
Re: LEFT JOIN problem   1,561 Steve Jordi 07/17/2006 09:30AM
Re: LEFT JOIN problem   1,581 Peter Brawley 07/17/2006 12:03PM
Re: LEFT JOIN problem   1,512 Steve Jordi 07/17/2006 10:23PM
(How) are subqueries optimized involving the same table?   2,248 Jakobus Dornier 07/13/2006 08:02AM
Re: (How) are subqueries optimized involving the same table?   1,617 Jakobus Dornier 07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?   1,589 Bob Field 07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?   1,694 Jakobus Dornier 07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?   1,570 Bob Field 07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?   1,473 Jakobus Dornier 07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?   1,641 Bob Field 07/13/2006 08:12AM
How to get some documents or articles on the query optimization of MySQL????   2,105 Hui Sun 07/10/2006 07:10AM
Re: How to get some documents or articles on the query optimization of MySQL????   1,537 KimSeong Loh 07/10/2006 05:12PM
min() vs limit optimization   4,758 Paul Medynski 07/02/2006 05:34PM
Re: min() vs limit optimization   1,892 Apachez 07/02/2006 08:26PM
Re: min() vs limit optimization   1,864 Paul Medynski 07/03/2006 05:22PM
Re: min() vs limit optimization   1,963 Apachez 07/04/2006 06:51AM
Slow Union Query Opimization. Need help.   5,445 Roland Meier 06/29/2006 12:50AM
Re: Slow Union Query Opimization. Need help.   2,282 Jay Pipes 06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.   2,557 Roland Meier 06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.   2,777 Anthony Willard 06/29/2006 08:24AM
querying time is too high   2,462 trinath somanchi 06/27/2006 07:31AM
Re: querying time is too high   1,600 Anthony Willard 06/29/2006 08:52AM
Re: querying time is too high   1,585 trinath somanchi 06/29/2006 12:48AM
Re: querying time is too high   1,666 Jim Daemon 06/28/2006 10:00AM
Boolean search and 99% cpu   2,024 Taiyo Rai 06/27/2006 07:17AM
Joining several multi-to-multi tables   2,982 adambrill1986 06/20/2006 11:59AM
Re: Joining several multi-to-multi tables   1,790 adambrill1986 06/23/2006 06:58AM
Re: Joining several multi-to-multi tables   1,636 adambrill1986 06/20/2006 12:21PM
Re: Joining several multi-to-multi tables   1,660 adambrill1986 06/20/2006 01:44PM
Re: Joining several multi-to-multi tables   1,582 Bill Karwin 06/20/2006 04:23PM
Re: Joining several multi-to-multi tables   1,586 KimSeong Loh 06/20/2006 06:02PM
Re: Joining several multi-to-multi tables   1,593 Bill Karwin 06/20/2006 01:02PM
Re: Joining several multi-to-multi tables   1,610 Bill Karwin 06/20/2006 12:14PM
no optimization?   2,051 Uwe 05/22/2006 05:47AM
Re: no optimization?   1,637 Apachez 06/18/2006 08:50PM
Re: no optimization?   1,573 Uwe 06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,162 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,528 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,864 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,813 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,872 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,334 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,798 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,697 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,783 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,674 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,735 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,718 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,695 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,829 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,684 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   5,070 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,951 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   3,016 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,509 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,994 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,845 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,547 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,833 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,512 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,254 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,158 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,128 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,365 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,903 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   13,037 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,626 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,195 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   6,129 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,348 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,730 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,124 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,732 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,698 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,094 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,586 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,701 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,559 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,967 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,330 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,594 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,485 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,373 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,367 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,157 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,521 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,859 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,348 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,068 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,085 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,207 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,351 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,534 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,671 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,899 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,254 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,067 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,892 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,948 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,102 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,159 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,552 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,581 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,938 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,266 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,598 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,624 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   2,045 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,622 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,433 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,074 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,138 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,942 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,796 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   21,811 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,671 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,208 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,896 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,906 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,167 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,963 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,393 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,085 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,980 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,803 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,890 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   2,054 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   2,013 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,831 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   3,018 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,260 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,405 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,615 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,247 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,300 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,853 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,943 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,634 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,683 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,648 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,717 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,673 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,975 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,643 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,200 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,481 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,058 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,884 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,539 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   3,063 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,230 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,314 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,266 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,979 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   16,399 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,679 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,251 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,624 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,256 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,655 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,092 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,542 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,593 Björn Steinbrink 04/26/2006 03:36AM
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.