MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.2.32 has been released 01/17/2018 12:45PM
•   MySQL Cluster 7.3.20 has been released 01/17/2018 12:36PM
•   MySQL Cluster 7.5.9 has been released 01/17/2018 12:05PM
•   MySQL Community Server 5.5.59 has been released 01/15/2018 12:30PM
•   MySQL Community Server 5.6.39 has been released 01/15/2018 11:13AM

Subject
Views
Written By
Posted
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
327
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
315
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
602
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
611
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
1,430
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
2,085
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
3,548
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
4,042
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
9,573
04/28/2007 06:20PM
60
12/17/2017 07:18AM
Muranweh, please don't double-post  
14
12/17/2017 09:48AM
Re: Compound index (pkey) not used when it should be  
27
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
24
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
26
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
31
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
25
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
37
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
25
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
23
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
16
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
19
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
19
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
17
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
15
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
21
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
16
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
17
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
20
12/01/2017 10:36AM
Re: Confirmation on possible parser bug  
21
11/30/2017 11:20AM
Re: Source code question related to sql_optimizer.cc line 8583  
29
11/28/2017 07:01AM
Re: Is Union Queries run in Parallel form or not.  
61
10/18/2017 08:32AM
Re: Is Union Queries run in Parallel form or not.  
50
10/18/2017 10:43PM
Re: Is Union Queries run in Parallel form or not.  
46
10/18/2017 10:55PM
Re: Is Union Queries run in Parallel form or not.  
83
10/19/2017 03:02AM
95
10/04/2017 06:03PM
Please don't duplicate posts  
53
09/21/2017 12:49PM
196
08/16/2017 09:09AM
Re: Help with explain on query  
68
08/16/2017 10:07AM
140
08/16/2017 12:56AM
Re: Optimizer Stablility  
73
08/16/2017 02:19AM
Re: Way to avoid fragmentation of MySQL tables  
73
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
71
07/30/2017 11:10PM
Re: Can anyone help speed up this query?  
117
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
89
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
128
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
75
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
88
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
85
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
92
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
81
06/23/2017 12:53AM
Re: Is there a better ANTLR grammar file for MySQL ?  
134
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
107
05/30/2017 07:57AM
Re: MySQL Index Advisor for SQL Tuning  
354
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
214
05/11/2017 08:08AM
176
05/02/2017 10:37AM
250
04/27/2017 11:30AM
Re: prepare don't work for optimize statement  
103
03/22/2017 01:34AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
137
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
146
02/13/2017 05:58AM
Re: Hiw to fast delete rows from table in relation?  
192
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
192
01/22/2017 04:03AM
458
01/06/2017 05:48AM
Re: Query not always using indexes  
210
01/06/2017 12:28PM
Re: Query not always using indexes  
284
01/09/2017 05:18AM
Re: Query not always using indexes  
273
01/09/2017 02:30AM
Re: Optimize subquery, replace IN() with JOIN  
284
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
303
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
344
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
271
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
293
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
292
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
322
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
285
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
224
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
280
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
271
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
315
11/16/2016 06:23AM
516
11/30/2016 09:55AM
Re: primary key vs covered index  
271
12/01/2016 01:39AM
Re: primary key vs covered index  
286
12/01/2016 03:38AM
Re: primary key vs covered index  
289
12/01/2016 03:57AM
Re: primary key vs covered index  
279
12/01/2016 04:16AM
Re: primary key vs covered index  
269
12/01/2016 04:25AM
558
10/27/2016 02:51PM
Re: MySQL subquery  
271
10/28/2016 01:03AM
Re: MySQL subquery  
304
11/06/2016 08:50PM
Re: MySQL subquery  
328
11/07/2016 01:39AM
1,220
10/14/2016 08:47AM
Re: Index on timestamp  
580
10/16/2016 04:40PM
639
10/12/2016 10:00AM
1,233
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
514
10/03/2016 03:40PM
Re: inner join vs left join - huge performance difference  
585
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
398
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
367
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
335
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
415
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
394
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
361
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
310
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
325
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
357
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
394
09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records  
10
09/20/2016 02:09PM
489
09/20/2016 09:21AM
Re: Preparse Query Rewrite Plugin DLL  
352
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
428
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
354
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
386
09/15/2016 11:34AM
Re: why the two query has a different execute plan?  
395
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
299
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
300
08/15/2016 09:28AM
601
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
376
07/08/2016 10:59AM
Re: how to optimize this sql?  
346
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
370
07/09/2016 11:04PM
Re: how to optimize this sql?  
340
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
483
07/14/2016 12:52PM
Re: Indexing for date column for range query  
405
07/09/2016 10:47PM
760
06/22/2016 04:44AM
Re: Help with partially unique index  
378
06/25/2016 10:45PM
Re: Help with partially unique index  
388
07/02/2016 03:33PM
Re: Help with partially unique index  
336
07/04/2016 12:50PM
This topic has been moved.:  My query take along time  
0
12/17/2017 09:37AM
This topic has been moved.:  Is Union Queries run in Parallel form or not.  
0
10/18/2017 10:56PM
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
...
18 »

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.