MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
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
MySQL Cluster 7.4.14 has been released 01/17/2017 10:38AM
MySQL Connector/C 6.1.9 GA has been released 01/10/2017 09:47AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 17
Subject Views Written By Posted
Sticky:  MySQL 8.0: CTEs (1 Posts)   261 Edwin Desouza 10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)   279 Edwin Desouza 09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)   1,093 Edwin Desouza 07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)   1,777 Edwin Desouza 04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)   3,182 Edwin Desouza 12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)   3,727 Edwin Desouza 07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)   9,246 Edwin DeSouza 04/28/2007 06:20PM
Query not always using indexes   63 K DBA 01/06/2017 05:48AM
Re: Query not always using indexes   25 Peter Brawley 01/06/2017 12:28PM
Re: Query not always using indexes   26 K DBA 01/09/2017 05:18AM
Re: Query not always using indexes   27 Øystein Grøvlen 01/09/2017 02:30AM
Optimize subquery, replace IN() with JOIN   166 Miron jajtic 11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN   98 Peter Brawley 11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN   87 Miron jajtic 11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN   71 Rick James 11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN   79 Peter Brawley 11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN   84 Miron jajtic 11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN   76 Peter Brawley 11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN   79 Miron jajtic 11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN   80 Peter Brawley 11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN   40 sahar gull 12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN   80 Øystein Grøvlen 11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN   77 Miron jajtic 11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN   90 Øystein Grøvlen 11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery   60 Edwin Desouza 12/23/2016 08:50AM
primary key vs covered index   125 marcin kot 11/30/2016 09:55AM
Re: primary key vs covered index   83 Øystein Grøvlen 12/01/2016 01:39AM
Re: primary key vs covered index   76 marcin kot 12/01/2016 03:38AM
Re: primary key vs covered index   75 Øystein Grøvlen 12/01/2016 03:57AM
Re: primary key vs covered index   72 marcin kot 12/01/2016 04:16AM
Re: primary key vs covered index   79 Øystein Grøvlen 12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser   145 Edwin Desouza 11/22/2016 10:58AM
MySQL subquery   181 harry sheng 10/27/2016 02:51PM
Re: MySQL subquery   91 Øystein Grøvlen 10/28/2016 01:03AM
Re: MySQL subquery   86 harry sheng 11/06/2016 08:50PM
Re: MySQL subquery   83 Øystein Grøvlen 11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance   176 Edwin Desouza 10/21/2016 09:58AM
Index on timestamp   202 Adeline M 10/14/2016 08:47AM
Re: Index on timestamp   101 Rick James 10/16/2016 04:40PM
MySQL 8.0: Descending Indexes   196 Edwin Desouza 10/12/2016 10:00AM
Pivot table with dynamic columns   260 Aram Mirzadeh 09/30/2016 06:03PM
Re: Pivot table with dynamic columns   124 Rick James 10/03/2016 03:40PM
inner join vs left join - huge performance difference   270 michael cook 07/06/2016 09:32AM
Re: inner join vs left join - huge performance difference   121 Peter Brawley 07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference   107 michael cook 07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference   103 michael cook 07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference   101 Peter Brawley 07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference   115 michael cook 07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference   101 michael cook 07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference   110 Peter Brawley 07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference   113 michael cook 07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference   108 Rick James 07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference   111 Peter Brawley 07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference   116 Isabella Swan 09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records   10 Brad Liu 09/20/2016 02:09PM
MySQL 8.0: Invisible Indexes   217 Edwin Desouza 09/20/2016 09:21AM
Preparse Query Rewrite Plugin DLL   401 Francois Haddad 08/12/2016 05:16PM
Re: Preparse Query Rewrite Plugin DLL   142 Georgi Kodinov 09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL   140 Francois Haddad 09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL   133 Tor Didriksen 09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL   132 Francois Haddad 09/15/2016 11:34AM
why the two query has a different execute plan?   335 h h 08/22/2016 02:55AM
Re: why the two query has a different execute plan?   150 Øystein Grøvlen 08/22/2016 05:08AM
Re: why the two query has a different execute plan?   139 Rick James 08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL   120 Francois Haddad 08/15/2016 09:28AM
how to optimize this sql?   291 h h 07/07/2016 07:38PM
Re: how to optimize this sql?   177 Peter Brawley 07/08/2016 10:59AM
Re: how to optimize this sql?   161 h h 07/12/2016 09:01PM
Re: how to optimize this sql?   165 Rick James 07/09/2016 11:04PM
Re: how to optimize this sql?   164 h h 07/12/2016 09:08PM
Re: how to optimize this sql?   154 Rick James 07/14/2016 12:52PM
Indexing for date column for range query   347 duc minh 07/05/2016 11:04PM
Re: Indexing for date column for range query   164 Rick James 07/09/2016 10:47PM
Help with partially unique index   399 El T 06/22/2016 04:44AM
Re: Help with partially unique index   184 Rick James 06/25/2016 10:45PM
Re: Help with partially unique index   166 El T 07/02/2016 03:33PM
Re: Help with partially unique index   175 Rick James 07/04/2016 12:50PM
Explain plans for InnoDB and Memory Engines   462 Jagan Kumar 05/02/2016 03:15PM
Re: Explain plans for InnoDB and Memory Engines   224 Peter Brawley 05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines   214 Øystein Grøvlen 05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines   222 Rick James 05/05/2016 10:18PM
MySQL Query Rewrite Plugins   560 Edwin Desouza 02/02/2016 09:48PM
why left join can not use unique index?   904 h h 12/07/2015 08:30PM
Re: why left join can not use unique index?   361 Rick James 12/08/2015 08:46PM
Re: why left join can not use unique index?   346 h h 12/11/2015 03:20AM
Re: why left join can not use unique index?   349 Rick James 12/15/2015 11:08AM
This topic has been moved.:  A stored function to remove diacritics and other chars   20 Marc Elbet 12/11/2015 03:50AM
prepared statement query takes 3s for a few hundred lines - query issue   708 Michael W. 11/16/2015 11:14AM
Re: prepared statement query takes 3s for a few hundred lines - query issue   328 Rick James 11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue   375 Michael W. 12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue   336 Rick James 12/07/2015 01:17AM
Why not use index   792 zhang peng 11/08/2015 11:14PM
Re: Why not use index   354 Peter Brawley 11/09/2015 11:42AM
Re: Why not use index   355 zhang peng 11/11/2015 12:17AM
Re: Why not use index   346 Øystein Grøvlen 11/10/2015 10:35AM
Re: Why not use index   379 zhang peng 11/11/2015 12:15AM
Re: Why not use index   348 Øystein Grøvlen 11/11/2015 03:40AM
Re: Why not use index   350 zhang peng 11/11/2015 07:29PM
Re: Why not use index   379 Peter Brawley 11/11/2015 11:00PM
Re: Why not use index   324 Øystein Grøvlen 11/12/2015 01:48AM
Re: Why not use index   351 zhang peng 11/16/2015 12:17AM
Google Update Optimizer system   706 Anik Bhowmik 11/09/2015 09:35PM
Re: Google Update Optimizer system   362 Peter Brawley 11/09/2015 10:12PM
Re: Google Update Optimizer system   349 Jonathan Stephens 11/10/2015 01:02AM
Normalize dump table   996 Jose Valle 10/11/2015 08:37PM
Re: Normalize dump table   337 Jose Valle 10/11/2015 08:42PM
Re: Normalize dump table   358 Antonio Valle 10/13/2015 01:41PM
Re: Normalize dump table   357 Rick James 10/17/2015 07:15PM
optimize query for index using between and group by   989 Raghavendra raghu 08/28/2015 03:21AM
Re: optimize query for index using between and group by   551 Rick James 08/29/2015 09:56AM
Re: optimize query for index using between and group by   428 Raghavendra raghu 08/31/2015 02:34AM
Parsing in MySQL Workbench: the ANTLR age   843 Edwin Desouza 08/14/2015 10:16AM
MySQL Optimizer: Hints   1,033 Edwin Desouza 07/29/2015 10:07AM
Index not working for date field used in between query   1,314 Shrinivasa rao 07/22/2015 11:48PM
Re: Index not working for date field used in between query   585 Rick James 07/26/2015 08:28AM
MyISAM using 'wrong' index   989 Danny Stommen 06/08/2015 04:14AM
Re: MyISAM using 'wrong' index   519 Rick James 06/09/2015 11:53PM
Re: MyISAM using 'wrong' index   524 Danny Stommen 06/30/2015 03:22AM
Re: MyISAM using 'wrong' index   504 Rick James 07/02/2015 09:28PM
Re: MyISAM using 'wrong' index   502 Danny Stommen 07/03/2015 03:16AM
Re: MyISAM using 'wrong' index   560 Rick James 07/04/2015 11:10AM
Re: MyISAM using 'wrong' index   498 Danny Stommen 07/07/2015 01:56AM
Re: MyISAM using 'wrong' index   479 Edwin Desouza 07/07/2015 09:10AM
Need help understanding optimizer behavior in 5.6   1,151 Aaron Craven 06/22/2015 08:30AM
Re: Need help understanding optimizer behavior in 5.6   540 Aaron Craven 06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6   494 Rick James 06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6   484 Aaron Craven 06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6   475 Rick James 06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6   488 Aaron Craven 06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6   473 Øystein Grøvlen 06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6   677 Aaron Craven 06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6   494 Aaron Craven 06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6   470 Øystein Grøvlen 07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6   468 Aaron Craven 07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6   532 Edwin Desouza 07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6   506 Aaron Craven 07/02/2015 07:48AM
MySQL 5.7: Optimizer Trace and EXPLAIN FORMAT=JSON   1,112 Edwin Desouza 05/25/2015 10:41AM
foreign key creation in a huge database   1,094 Raffael Vendrametto 03/05/2015 04:05PM
Please do NOT duplicate posts   579 Peter Brawley 03/05/2015 05:42PM
Query Taking 2.5hrs on 5.6.20 version   1,361 ch srinivas 03/04/2015 01:30AM
Re: Query Taking 2.5hrs on 5.6.20 version   641 Peter Brawley 03/04/2015 12:15PM
Re: Query Taking 2.5hrs on 5.6.20 version   577 Rick James 03/04/2015 08:18PM
Query optimisation advice   1,384 Paul Feely 01/08/2015 11:02PM
Re: Query optimisation advice   738 Rick James 01/10/2015 01:22AM
Re: Query optimisation advice   699 Paul Feely 01/11/2015 05:50PM
Re: Query optimisation advice   666 Rick James 01/12/2015 10:35PM
actual Size calculation of mysql table (engine innodb)   1,285 Afaque Ahmad Siddiqui 12/10/2014 09:38AM
Re: actual Size calculation of mysql table (engine innodb)   680 Rick James 12/12/2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)   701 Rick James 12/12/2014 08:36PM
MySQL cash optimization   1,473 Sasha Katsman 11/27/2014 06:33AM
Re: MySQL cash optimization   795 Peter Brawley 11/27/2014 04:34PM
Re: MySQL cash optimization   621 Sasha Katsman 12/09/2014 04:33AM
Re: MySQL cache optimization   603 Peter Brawley 12/09/2014 12:28PM
how to tune for optimizer_search_depth?   1,379 jongse park 12/03/2014 12:13AM
Re: how to tune for optimizer_search_depth?   793 Rick James 12/03/2014 11:33PM
Re: how to tune for optimizer_search_depth?   828 Øystein Grøvlen 12/08/2014 05:32AM
MySQL Optimizer Cost Model   1,375 Edwin Desouza 10/24/2014 10:37AM
Need help to create index on join statments   1,448 Neil Sorathia 10/08/2014 06:24PM
Re: Need help to create index on join statments   708 Neil Sorathia 10/09/2014 09:46AM
Re: Need help to create index on join statments   717 Rick James 10/11/2014 01:37PM
Better Performance for JOINs Not Using Indexes   1,347 Edwin Desouza 10/03/2014 01:48PM
A Multi-Table Trick to Speed up Single-Table UPDATE/DELETE Statements   1,491 Edwin Desouza 10/03/2014 01:47PM
MySQL 5.7: Optimizer Hints + Query Rewrite   1,430 Edwin Desouza 10/01/2014 08:53AM
Intermediate Query Results   1,676 Ashwini Singh 09/12/2014 08:37AM
Re: Intermediate Query Results   803 Rick James 09/13/2014 09:23PM
Re: Intermediate Query Results   944 Øystein Grøvlen 09/15/2014 05:42AM
All records scanning using "LIKe" and "IN" operaters   1,581 ch srinivas 06/28/2014 01:43PM
Re: All records scanning using "LIKe" and "IN" operaters   769 Peter Brawley 06/28/2014 02:22PM
Re: All records scanning using "LIKe" and "IN" operaters   738 Øystein Grøvlen 08/28/2014 03:47PM
Help me to optimize my sql query   1,403 GAURAV JAIN 08/21/2014 07:29AM
Re: Help me to optimize my sql query   739 Rick James 08/22/2014 06:50AM
How could this SQL be optimized?   1,664 feng guo 05/29/2014 11:26PM
Re: How could this SQL be optimized?   840 Øystein Grøvlen 05/30/2014 02:41AM
Re: How could this SQL be optimized?   901 feng guo 05/30/2014 02:46AM
Re: How could this SQL be optimized?   724 Marion Gordon 08/21/2014 11:03PM
Re: How could this SQL be optimized?   700 Øystein Grøvlen 08/22/2014 01:54AM
simple uses of order by datetime keep causing 'using filesort'   1,608 park albert 08/19/2014 05:44PM
Re: simple uses of order by datetime keep causing 'using filesort'   803 Rick James 08/20/2014 07:34PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 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.