MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.3.30 has been released 07/14/2020 12:50PM
•   MySQL Cluster 7.4.29 has been released 07/14/2020 02:18AM
•   MySQL Cluster 7.5.19 has been released 07/14/2020 02:09AM
•   MySQL Cluster 7.6.15 has been released 07/14/2020 01:57AM
•   MySQL Connector/J 8.0.21 has been released 07/13/2020 09:07AM

Subject
Views
Written By
Posted
Re: how to speed up query on a table with over 20million records?  
385
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
316
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
379
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
337
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
358
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
308
03/26/2018 02:41AM
Re: optimize range query(using between, group by and order by)  
531
03/20/2018 03:52AM
Re: Slow DELETE-Statement since update on 5.7  
480
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
488
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
500
03/20/2018 02:09AM
414
03/19/2018 05:48PM
376
03/01/2018 02:27PM
Re: Indexing a small table increases the query cost  
325
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
364
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
303
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
290
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
366
03/01/2018 03:15AM
450
01/23/2018 11:23AM
684
12/17/2017 07:18AM
Muranweh, please don't double-post  
268
12/17/2017 09:48AM
Re: Compound index (pkey) not used when it should be  
395
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
379
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
377
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
376
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
376
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
394
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
360
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
399
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
365
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
363
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
359
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
377
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
372
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
385
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
358
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
371
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
369
12/01/2017 10:36AM
Re: Confirmation on possible parser bug  
286
11/30/2017 11:20AM
Re: Source code question related to sql_optimizer.cc line 8583  
336
11/28/2017 07:01AM
Re: Is Union Queries run in Parallel form or not.  
373
10/18/2017 08:32AM
Re: Is Union Queries run in Parallel form or not.  
475
10/18/2017 10:43PM
Re: Is Union Queries run in Parallel form or not.  
369
10/18/2017 10:55PM
Re: Is Union Queries run in Parallel form or not.  
421
10/19/2017 03:02AM
441
10/04/2017 06:03PM
Please don't duplicate posts  
377
09/21/2017 12:49PM
536
08/16/2017 09:09AM
Re: Help with explain on query  
303
08/16/2017 10:07AM
517
08/16/2017 12:56AM
Re: Optimizer Stablility  
346
08/16/2017 02:19AM
Re: Way to avoid fragmentation of MySQL tables  
425
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
327
07/30/2017 11:10PM
Re: Can anyone help speed up this query?  
375
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
389
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
385
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
351
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
304
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
370
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
380
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
372
06/23/2017 12:53AM
Re: Is there a better ANTLR grammar file for MySQL ?  
739
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
672
05/30/2017 07:57AM
Re: MySQL Index Advisor for SQL Tuning  
1,705
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
992
05/11/2017 08:08AM
489
05/02/2017 10:37AM
645
04/27/2017 11:30AM
Re: prepare don't work for optimize statement  
344
03/22/2017 01:34AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
318
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
410
02/13/2017 05:58AM
Re: Hiw to fast delete rows from table in relation?  
399
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
390
01/22/2017 04:03AM
1,495
01/06/2017 05:48AM
Re: Query not always using indexes  
512
01/06/2017 12:28PM
Re: Query not always using indexes  
560
01/09/2017 05:18AM
Re: Query not always using indexes  
530
01/09/2017 02:30AM
Re: Optimize subquery, replace IN() with JOIN  
604
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
683
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
615
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
599
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
634
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
580
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
676
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
601
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
437
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
528
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
573
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
611
11/16/2016 06:23AM
1,049
11/30/2016 09:55AM
Re: primary key vs covered index  
542
12/01/2016 01:39AM
Re: primary key vs covered index  
551
12/01/2016 03:38AM
Re: primary key vs covered index  
575
12/01/2016 03:57AM
Re: primary key vs covered index  
514
12/01/2016 04:16AM
Re: primary key vs covered index  
453
12/01/2016 04:25AM
905
10/27/2016 02:51PM
Re: MySQL subquery  
531
10/28/2016 01:03AM
Re: MySQL subquery  
535
11/06/2016 08:50PM
Re: MySQL subquery  
571
11/07/2016 01:39AM
6,656
10/14/2016 08:47AM
Re: Index on timestamp  
2,764
10/16/2016 04:40PM
949
10/12/2016 10:00AM
5,199
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
1,810
10/03/2016 03:40PM
Re: inner join vs left join - huge performance difference  
2,241
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
1,389
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
1,160
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
1,066
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
1,136
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
1,051
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
1,054
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
840
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
949
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
1,082
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
1,150
09/27/2016 07:13AM
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
...
19 »

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.