MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.6.5-dmr has been released 04/20/2018 07:21PM
•   MySQL Cluster 7.4.20 has been released 04/20/2018 08:56AM
•   MySQL Cluster 7.5.10 has been released 04/20/2018 06:34AM
•   MySQL Cluster 7.3.21 has been released 04/20/2018 04:59AM
•   MySQL Enterprise Monitor 8.0.0 GA has been released 04/19/2018 11:00AM

Subject
Views
Written By
Posted
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
359
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
344
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
639
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
657
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
1,468
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
2,132
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
3,566
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
4,074
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
9,662
04/28/2007 06:20PM
Re: how to speed up query on a table with over 20million records?  
21
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
19
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
20
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
12
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
16
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
20
03/26/2018 02:41AM
Re: optimize range query(using between, group by and order by)  
43
03/20/2018 03:52AM
Re: Slow DELETE-Statement since update on 5.7  
22
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
29
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
60
03/20/2018 02:09AM
41
03/01/2018 02:27PM
Re: Indexing a small table increases the query cost  
20
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
22
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
20
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
13
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
36
03/01/2018 03:15AM
55
01/23/2018 11:23AM
120
12/17/2017 07:18AM
Muranweh, please don't double-post  
29
12/17/2017 09:48AM
Re: Compound index (pkey) not used when it should be  
59
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
48
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
58
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
55
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
51
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
60
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
47
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
45
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
38
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
37
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
42
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
42
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
40
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
51
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
37
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
37
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
40
12/01/2017 10:36AM
Re: Confirmation on possible parser bug  
39
11/30/2017 11:20AM
Re: Source code question related to sql_optimizer.cc line 8583  
47
11/28/2017 07:01AM
Re: Is Union Queries run in Parallel form or not.  
91
10/18/2017 08:32AM
Re: Is Union Queries run in Parallel form or not.  
87
10/18/2017 10:43PM
Re: Is Union Queries run in Parallel form or not.  
72
10/18/2017 10:55PM
Re: Is Union Queries run in Parallel form or not.  
116
10/19/2017 03:02AM
116
10/04/2017 06:03PM
Please don't duplicate posts  
66
09/21/2017 12:49PM
224
08/16/2017 09:09AM
Re: Help with explain on query  
84
08/16/2017 10:07AM
166
08/16/2017 12:56AM
Re: Optimizer Stablility  
98
08/16/2017 02:19AM
Re: Way to avoid fragmentation of MySQL tables  
92
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
90
07/30/2017 11:10PM
Re: Can anyone help speed up this query?  
134
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
115
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
149
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
101
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
106
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
105
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
117
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
105
06/23/2017 12:53AM
Re: Is there a better ANTLR grammar file for MySQL ?  
179
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
144
05/30/2017 07:57AM
Re: MySQL Index Advisor for SQL Tuning  
485
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
322
05/11/2017 08:08AM
200
05/02/2017 10:37AM
309
04/27/2017 11:30AM
Re: prepare don't work for optimize statement  
131
03/22/2017 01:34AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
153
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
164
02/13/2017 05:58AM
Re: Hiw to fast delete rows from table in relation?  
206
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
209
01/22/2017 04:03AM
535
01/06/2017 05:48AM
Re: Query not always using indexes  
239
01/06/2017 12:28PM
Re: Query not always using indexes  
308
01/09/2017 05:18AM
Re: Query not always using indexes  
300
01/09/2017 02:30AM
Re: Optimize subquery, replace IN() with JOIN  
305
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
320
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
364
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
291
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
332
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
312
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
353
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
309
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
265
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
301
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
302
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
346
11/16/2016 06:23AM
572
11/30/2016 09:55AM
Re: primary key vs covered index  
296
12/01/2016 01:39AM
Re: primary key vs covered index  
305
12/01/2016 03:38AM
Re: primary key vs covered index  
315
12/01/2016 03:57AM
Re: primary key vs covered index  
311
12/01/2016 04:16AM
Re: primary key vs covered index  
289
12/01/2016 04:25AM
593
10/27/2016 02:51PM
Re: MySQL subquery  
297
10/28/2016 01:03AM
Re: MySQL subquery  
332
11/06/2016 08:50PM
Re: MySQL subquery  
355
11/07/2016 01:39AM
1,719
10/14/2016 08:47AM
Re: Index on timestamp  
789
10/16/2016 04:40PM
692
10/12/2016 10:00AM
1,486
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
637
10/03/2016 03:40PM
Re: inner join vs left join - huge performance difference  
691
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
466
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
411
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
375
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
461
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
438
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
419
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
337
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
358
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
411
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
458
09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records  
10
09/20/2016 02:09PM
505
09/20/2016 09:21AM
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.