MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Enterprise Monitor 3.3.4 has been released 06/13/2017 01:27PM
•   MySQL Enterprise Monitor 3.2.8 has been released 06/13/2017 12:49PM
•   MySQL Enterprise Monitor 3.4.1 has been released 06/06/2017 10:48AM

Subject
Views
Written By
Posted
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
165
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
203
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
486
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
481
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
1,325
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
1,992
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
3,368
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
3,906
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
9,415
04/28/2007 06:20PM
Re: Can anyone help speed up this query?  
21
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
18
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
18
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
8
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
7
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
19
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
18
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
11
06/23/2017 12:53AM
Re: Is there a better ANTLR grammar file for MySQL ?  
29
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
24
05/30/2017 07:57AM
Re: MySQL Index Advisor for SQL Tuning  
67
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
39
05/11/2017 08:08AM
82
05/02/2017 10:37AM
77
04/27/2017 11:30AM
Re: prepare don't work for optimize statement  
49
03/22/2017 01:34AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
80
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
93
02/13/2017 05:58AM
Re: Hiw to fast delete rows from table in relation?  
118
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
131
01/22/2017 04:03AM
286
01/06/2017 05:48AM
Re: Query not always using indexes  
129
01/06/2017 12:28PM
Re: Query not always using indexes  
217
01/09/2017 05:18AM
Re: Query not always using indexes  
204
01/09/2017 02:30AM
Re: Optimize subquery, replace IN() with JOIN  
208
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
222
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
192
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
190
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
212
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
197
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
216
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
212
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
155
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
194
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
182
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
226
11/16/2016 06:23AM
337
11/30/2016 09:55AM
Re: primary key vs covered index  
203
12/01/2016 01:39AM
Re: primary key vs covered index  
222
12/01/2016 03:38AM
Re: primary key vs covered index  
208
12/01/2016 03:57AM
Re: primary key vs covered index  
187
12/01/2016 04:16AM
Re: primary key vs covered index  
218
12/01/2016 04:25AM
437
10/27/2016 02:51PM
Re: MySQL subquery  
202
10/28/2016 01:03AM
Re: MySQL subquery  
239
11/06/2016 08:50PM
Re: MySQL subquery  
226
11/07/2016 01:39AM
608
10/14/2016 08:47AM
Re: Index on timestamp  
304
10/16/2016 04:40PM
499
10/12/2016 10:00AM
Re: Pivot table with dynamic columns  
351
10/03/2016 03:40PM
Re: inner join vs left join - huge performance difference  
350
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
254
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
254
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
237
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
293
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
245
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
256
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
219
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
225
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
246
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
246
09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records  
10
09/20/2016 02:09PM
406
09/20/2016 09:21AM
Re: Preparse Query Rewrite Plugin DLL  
252
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
311
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
261
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
292
09/15/2016 11:34AM
Re: why the two query has a different execute plan?  
261
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
241
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
237
08/15/2016 09:28AM
486
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
289
07/08/2016 10:59AM
Re: how to optimize this sql?  
284
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
283
07/09/2016 11:04PM
Re: how to optimize this sql?  
268
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
260
07/14/2016 12:52PM
Re: Indexing for date column for range query  
291
07/09/2016 10:47PM
631
06/22/2016 04:44AM
Re: Help with partially unique index  
305
06/25/2016 10:45PM
Re: Help with partially unique index  
295
07/02/2016 03:33PM
Re: Help with partially unique index  
281
07/04/2016 12:50PM
Re: Explain plans for InnoDB and Memory Engines  
322
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
309
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
321
05/05/2016 10:18PM
728
02/02/2016 09:48PM
1,256
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
472
12/08/2015 08:46PM
Re: why left join can not use unique index?  
469
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
473
12/15/2015 11:08AM
This topic has been moved.:  A stored function to remove diacritics and other chars  
20
12/11/2015 03:50AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
426
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
519
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
437
12/07/2015 01:17AM
968
11/08/2015 11:14PM
Re: Why not use index  
460
11/09/2015 11:42AM
Re: Why not use index  
501
11/11/2015 12:17AM
Re: Why not use index  
445
11/10/2015 10:35AM
Re: Why not use index  
487
11/11/2015 12:15AM
Re: Why not use index  
458
11/11/2015 03:40AM
Re: Why not use index  
472
11/11/2015 07:29PM
Re: Why not use index  
487
11/11/2015 11:00PM
Re: Why not use index  
450
11/12/2015 01:48AM
Re: Why not use index  
469
11/16/2015 12:17AM
875
11/09/2015 09:35PM
Re: Google Update Optimizer system  
458
11/09/2015 10:12PM
Re: Google Update Optimizer system  
450
11/10/2015 01:02AM
1,241
10/11/2015 08:37PM
Re: Normalize dump table  
430
10/11/2015 08:42PM
Re: Normalize dump table  
476
10/13/2015 01:41PM
Re: Normalize dump table  
463
10/17/2015 07:15PM
Re: optimize query for index using between and group by  
727
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
538
08/31/2015 02:34AM
1,233
07/29/2015 10:07AM
Re: Index not working for date field used in between query  
747
07/26/2015 08:28AM
1,160
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
632
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
657
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
720
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
602
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
680
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
602
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
577
07/07/2015 09:10AM
Re: Need help understanding optimizer behavior in 5.6  
657
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
598
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
591
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
581
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
587
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
577
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
836
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
597
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
604
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
582
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
632
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
599
07/02/2015 07:48AM
This topic has been moved.:  Improve search when using IN() ORDER BY PRIMARY and LIMIT  
0
02/11/2017 01:36PM
Pages:
1 2 3 4 5
...
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.