MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL for Visual Studio 2.0.5 m4 release has been released 04/25/2017 04:25AM
MySQL Connector/Python 2.1.6 GA has been released 04/18/2017 08:49AM
MySQL Router 2.1.3 GA has been released 04/12/2017 12:17PM
MySQL Shell 1.0.9 GA has been released 04/12/2017 12:16PM
MySQL Cluster 7.5.6 has been released 04/11/2017 02:22AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
Why do mysql use temporary and filesort here?   2,960 Johannes Fosseus 09/08/2006 04:50AM
Re: Why do mysql use temporary and filesort here?   1,923 Björn Steinbrink 09/08/2006 06:36AM
slow selects   2,339 Danie Van der Walt 08/31/2006 08:02AM
Re: slow selects   1,654 Toa Sty 08/31/2006 08:43AM
Re: slow selects   1,633 Danie Van der Walt 08/31/2006 09:06AM
Re: slow selects   1,635 Toa Sty 09/01/2006 03:04AM
Re: slow selects   1,653 Danie Van der Walt 09/01/2006 04:17AM
Re: slow selects   1,800 Toa Sty 09/01/2006 04:50AM
Re: slow selects   1,614 Danie Van der Walt 09/01/2006 07:24AM
Re: slow selects   1,570 Toa Sty 09/01/2006 08:16AM
Re: slow selects   1,650 Danie Van der Walt 09/02/2006 12:52PM
Query Optimization   2,331 Will Buckner 08/21/2006 11:05AM
Re: Query Optimization   1,494 Bill Karwin 08/21/2006 06:44PM
Re: Query Optimization   1,526 Will Buckner 08/27/2006 11:50PM
Re: Query Optimization   1,569 Anthony Willard 08/28/2006 07:33AM
Optimizing a UNION Query   5,610 Charles Salvia 08/23/2006 08:16PM
Re: Optimizing a UNION Query   2,414 Toa Sty 08/24/2006 05:28AM
Re: Optimizing a UNION Query   2,465 Charles Salvia 08/24/2006 12:12PM
Re: Optimizing a UNION Query   4,897 Toa Sty 08/25/2006 06:14AM
Re: Optimizing a UNION Query   2,407 Toa Sty 08/24/2006 04:59AM
Really need help with optimization   2,493 Anders Bergman 08/22/2006 01:43PM
Re: Really need help with optimization   1,565 Toa Sty 08/23/2006 12:50AM
Re: Really need help with optimization   1,622 Anders Bergman 08/23/2006 01:24PM
Re: Really need help with optimization   1,576 Toa Sty 08/24/2006 04:53AM
Re: Really need help with optimization   1,572 Anders Bergman 08/22/2006 01:46PM
Left Join Problem   2,263 Clodelio Delfino 08/22/2006 11:30PM
Re: Left Join Problem   1,546 Bob Field 08/23/2006 09:00AM
Re: Left Join Problem   1,579 Clodelio Delfino 08/23/2006 06:53PM
Re: Left Join Problem   1,548 Bob Field 08/23/2006 07:12PM
Re: Left Join Problem   1,653 Clodelio Delfino 08/23/2006 11:01PM
optimizing the query.   2,123 ronak desai 07/26/2006 07:13AM
Re: optimizing the query.   1,581 Yogesh Salvi 08/22/2006 12:37PM
Re: optimizing the query.   1,629 Toa Sty 08/04/2006 04:50AM
Re: optimizing the query.   1,582 KimSeong Loh 07/27/2006 12:13AM
cant get LEFT JOIN to work properly when ORDER'ing BY   1,949 Liutauras 08/20/2006 02:11AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY   1,479 Liutauras 08/22/2006 03:26AM
cant get LEFT JOIN to work properly when ORDER'ing BY   5,952 Liutauras 08/20/2006 01:36AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY   8,046 Toa Sty 08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY   3,829 Toa Sty 08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY   2,798 Liutauras 08/22/2006 03:25AM
Force Table Selection Order in JOIN Statement?   8,035 Frank Osterberg 08/21/2006 02:39AM
Re: Force Table Selection Order in JOIN Statement?   8,654 Toa Sty 08/21/2006 06:24AM
ORDER BY RAND() taking too much time   9,376 Yogesh Salvi 04/29/2006 05:30AM
Re: ORDER BY RAND() taking too much time   3,413 Erin ONeill 06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time   2,375 Yogesh Salvi 05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time   2,812 Yogesh Salvi 05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time   3,074 Ravenous Bugblatter Beast 08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time   2,615 Yogesh Salvi 05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time   3,747 Yogesh Salvi 05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time   3,227 Björn Steinbrink 05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time   3,373 Sebastien Caisse 05/01/2006 08:49AM
How to create on-the-fly index on derived table?   9,928 Nathan Cheng 07/25/2006 01:05PM
Re: How to create on-the-fly index on derived table?   5,516 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,405 Ed Stone 08/09/2006 03:48PM
EXISTS() optimization   18,791 Rob Blick 06/07/2006 10:00AM
Re: EXISTS() optimization   6,139 bill stamp 07/25/2006 07:54AM
Re: EXISTS() optimization   5,410 Nathan Cheng 07/25/2006 01:13PM
Re: EXISTS() optimization   4,914 Toa Sty 08/04/2006 04:45AM
Too many rows being read   2,490 preston 08/02/2006 02:02PM
Re: Too many rows being read   1,559 Bob Field 08/02/2006 02:18PM
Why does this query filesort?   2,399 Jim Daemon 07/27/2006 12:05PM
Re: Why does this query filesort?   1,587 KimSeong Loh 08/01/2006 11:14PM
optimize dynamic sql   2,866 Bhupesh Tripathi 07/28/2006 03:33AM
query of tables with a longblob   2,162 paul obyrne 06/23/2006 11:44AM
Re: query of tables with a longblob   1,519 Nathan Cheng 07/25/2006 01:26PM
Optimizing (a=b and c=d) OR (e=f and g=h)   2,252 a.h.s. boy 07/20/2006 12:07PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)   1,515 KimSeong Loh 07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)   1,541 a.h.s. boy 07/20/2006 10:09PM
With vs Without Primary Key in a particular case   6,407 Martin Feng 07/19/2006 11:02PM
Re: With vs Without Primary Key in a particular case   2,575 KimSeong Loh 07/20/2006 05:35PM
SELECT DISTINCT vs UNIQUE KEY   9,090 Martin Feng 07/19/2006 06:11AM
LEFT JOIN problem   2,897 Steve Jordi 07/17/2006 07:13AM
Re: LEFT JOIN problem   1,611 Peter Brawley 07/17/2006 08:07AM
Re: LEFT JOIN problem   1,572 Steve Jordi 07/17/2006 09:30AM
Re: LEFT JOIN problem   1,590 Peter Brawley 07/17/2006 12:03PM
Re: LEFT JOIN problem   1,524 Steve Jordi 07/17/2006 10:23PM
(How) are subqueries optimized involving the same table?   2,278 Jakobus Dornier 07/13/2006 08:02AM
Re: (How) are subqueries optimized involving the same table?   1,635 Jakobus Dornier 07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?   1,599 Bob Field 07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?   1,708 Jakobus Dornier 07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?   1,600 Bob Field 07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?   1,483 Jakobus Dornier 07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?   1,657 Bob Field 07/13/2006 08:12AM
How to get some documents or articles on the query optimization of MySQL????   2,146 Hui Sun 07/10/2006 07:10AM
Re: How to get some documents or articles on the query optimization of MySQL????   1,555 KimSeong Loh 07/10/2006 05:12PM
min() vs limit optimization   4,916 Paul Medynski 07/02/2006 05:34PM
Re: min() vs limit optimization   1,910 Apachez 07/02/2006 08:26PM
Re: min() vs limit optimization   1,896 Paul Medynski 07/03/2006 05:22PM
Re: min() vs limit optimization   2,071 Apachez 07/04/2006 06:51AM
Slow Union Query Opimization. Need help.   5,690 Roland Meier 06/29/2006 12:50AM
Re: Slow Union Query Opimization. Need help.   2,307 Jay Pipes 06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.   2,583 Roland Meier 06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.   2,801 Anthony Willard 06/29/2006 08:24AM
querying time is too high   2,493 trinath somanchi 06/27/2006 07:31AM
Re: querying time is too high   1,616 Anthony Willard 06/29/2006 08:52AM
Re: querying time is too high   1,598 trinath somanchi 06/29/2006 12:48AM
Re: querying time is too high   1,682 Jim Daemon 06/28/2006 10:00AM
Boolean search and 99% cpu   2,065 Taiyo Rai 06/27/2006 07:17AM
Joining several multi-to-multi tables   3,027 adambrill1986 06/20/2006 11:59AM
Re: Joining several multi-to-multi tables   1,806 adambrill1986 06/23/2006 06:58AM
Re: Joining several multi-to-multi tables   1,644 adambrill1986 06/20/2006 12:21PM
Re: Joining several multi-to-multi tables   1,677 adambrill1986 06/20/2006 01:44PM
Re: Joining several multi-to-multi tables   1,604 Bill Karwin 06/20/2006 04:23PM
Re: Joining several multi-to-multi tables   1,600 KimSeong Loh 06/20/2006 06:02PM
Re: Joining several multi-to-multi tables   1,613 Bill Karwin 06/20/2006 01:02PM
Re: Joining several multi-to-multi tables   1,626 Bill Karwin 06/20/2006 12:14PM
no optimization?   2,074 Uwe 05/22/2006 05:47AM
Re: no optimization?   1,653 Apachez 06/18/2006 08:50PM
Re: no optimization?   1,593 Uwe 06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,179 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,570 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,969 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,837 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,891 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,387 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,815 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,713 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,920 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,694 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,750 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,736 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,717 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,844 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,701 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   5,253 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,968 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   3,033 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,533 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   12,073 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,869 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,676 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,860 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,547 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,272 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,173 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,153 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,513 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,916 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   13,226 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,659 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,221 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   6,164 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,377 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,880 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,170 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,767 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,723 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,127 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,625 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,724 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,615 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   3,035 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,344 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,616 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,508 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,428 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,384 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,223 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,541 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,906 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,373 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,083 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,102 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,228 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,360 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,545 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,687 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   6,006 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,352 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,084 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,905 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,989 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,121 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,180 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,576 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,596 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,963 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,296 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,616 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,639 Peter Brawley 05/15/2006 12:31PM
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.