MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/J 5.1.44 has been released 08/30/2017 04:41AM

Advanced Search
New Topic
Pages:
1 2 3 4 5
...
17 »

Subject
Views
Written By
Posted
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
221
Edwin Desouza
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
254
Edwin Desouza
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
543
Edwin Desouza
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
532
Edwin Desouza
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
1,377
Edwin Desouza
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
2,033
Edwin Desouza
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
3,470
Edwin Desouza
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
3,990
Edwin Desouza
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
9,486
Edwin DeSouza
04/28/2007 06:20PM
Help with explain on query  
64
Alex Titley
08/16/2017 09:09AM
Re: Help with explain on query  
27
Peter Brawley
08/16/2017 10:07AM
Optimizer Stablility  
67
Chris Reston
08/16/2017 12:56AM
Re: Optimizer Stablility  
29
Øystein Grøvlen
08/16/2017 02:19AM
Way to avoid fragmentation of MySQL tables  
73
Priya Pawar
07/30/2017 11:01AM
Re: Way to avoid fragmentation of MySQL tables  
32
Peter Brawley
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
32
Priya Pawar
07/30/2017 11:10PM
MySQL 8.0.2: Introducing Window Functions  
75
Edwin Desouza
07/18/2017 10:33AM
Can anyone help speed up this query?  
122
Search Team
06/21/2017 11:07AM
Re: Can anyone help speed up this query?  
77
Peter Brawley
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
52
Search Team
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
83
Peter Brawley
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
43
Search Team
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
46
Peter Brawley
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
44
Øystein Grøvlen
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
48
Search Team
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
43
Øystein Grøvlen
06/23/2017 12:53AM
Is there a better ANTLR grammar file for MySQL ?  
142
Bill Nicholson
05/28/2017 05:07PM
Re: Is there a better ANTLR grammar file for MySQL ?  
73
Edwin Desouza
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
59
Edwin Desouza
05/30/2017 07:57AM
MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance  
152
Edwin Desouza
05/23/2017 11:01AM
MySQL Index Advisor for SQL Tuning  
277
Chaitanya Challa
05/10/2017 09:12PM
Re: MySQL Index Advisor for SQL Tuning  
174
Edwin Desouza
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
104
Chaitanya Challa
05/11/2017 08:08AM
MySQL 8.0: CTEs Recursive Query Throwdown  
136
Edwin Desouza
05/05/2017 06:14PM
MySQL 8.0: GROUPING function  
118
Edwin Desouza
05/02/2017 10:37AM
How to Analyze and Tune MySQL Queries for Better Performance  
116
Edwin Desouza
04/27/2017 11:32AM
MySQL 8.0: Optimizer: What's New  
129
Edwin Desouza
04/27/2017 11:31AM
MySQL 8.0 Optimizer Guide  
130
Edwin Desouza
04/27/2017 11:30AM
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows  
128
Edwin Desouza
04/12/2017 11:57AM
MySQL 8.0: Improved performance with CTE  
139
Edwin Desouza
04/12/2017 11:57AM
MySQL 5.7: What to Do When the Optimizer Overestimates the Condition Filtering Effect  
130
Edwin Desouza
03/24/2017 11:30AM
prepare don't work for optimize statement  
207
Long WU
03/22/2017 12:30AM
Re: prepare don't work for optimize statement  
70
Øystein Grøvlen
03/22/2017 01:34AM
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account  
173
Edwin Desouza
03/17/2017 02:49PM
Improve search when using IN() ORDER BY PRIMARY and LIMIT  
307
jon sans
02/11/2017 07:17AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
103
jon sans
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
115
Øystein Grøvlen
02/13/2017 05:58AM
MySQL Performance Tuning: Optimizer Hints  
209
Edwin Desouza
02/04/2017 09:09PM
Hiw to fast delete rows from table in relation?  
281
Andrzej Borucki
01/22/2017 02:21AM
Re: Hiw to fast delete rows from table in relation?  
157
Andrzej Borucki
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
160
Andrzej Borucki
01/22/2017 04:03AM
Query not always using indexes  
349
K DBA
01/06/2017 05:48AM
Re: Query not always using indexes  
162
Peter Brawley
01/06/2017 12:28PM
Re: Query not always using indexes  
245
K DBA
01/09/2017 05:18AM
Re: Query not always using indexes  
229
Øystein Grøvlen
01/09/2017 02:30AM
Optimize subquery, replace IN() with JOIN  
436
Miron jajtic
11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN  
236
Peter Brawley
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
256
Miron jajtic
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
300
Rick James
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
224
Peter Brawley
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
238
Miron jajtic
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
235
Peter Brawley
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
258
Miron jajtic
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
237
Peter Brawley
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
176
sahar gull
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
226
Øystein Grøvlen
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
213
Miron jajtic
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
257
Øystein Grøvlen
11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery  
296
Edwin Desouza
12/23/2016 08:50AM
primary key vs covered index  
395
marcin kot
11/30/2016 09:55AM
Re: primary key vs covered index  
232
Øystein Grøvlen
12/01/2016 01:39AM
Re: primary key vs covered index  
247
marcin kot
12/01/2016 03:38AM
Re: primary key vs covered index  
249
Øystein Grøvlen
12/01/2016 03:57AM
Re: primary key vs covered index  
224
marcin kot
12/01/2016 04:16AM
Re: primary key vs covered index  
240
Øystein Grøvlen
12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser  
419
Edwin Desouza
11/22/2016 10:58AM
MySQL subquery  
494
harry sheng
10/27/2016 02:51PM
Re: MySQL subquery  
230
Øystein Grøvlen
10/28/2016 01:03AM
Re: MySQL subquery  
262
harry sheng
11/06/2016 08:50PM
Re: MySQL subquery  
268
Øystein Grøvlen
11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance  
423
Edwin Desouza
10/21/2016 09:58AM
Index on timestamp  
862
Adeline M
10/14/2016 08:47AM
Re: Index on timestamp  
429
Rick James
10/16/2016 04:40PM
MySQL 8.0: Descending Indexes  
552
Edwin Desouza
10/12/2016 10:00AM
Pivot table with dynamic columns  
956
Aram Mirzadeh
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
420
Rick James
10/03/2016 03:40PM
inner join vs left join - huge performance difference  
1,094
michael cook
07/06/2016 09:32AM
Re: inner join vs left join - huge performance difference  
451
Peter Brawley
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
319
michael cook
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
298
michael cook
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
275
Peter Brawley
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
343
michael cook
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
307
michael cook
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
307
Peter Brawley
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
262
michael cook
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
272
Rick James
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
303
Peter Brawley
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
305
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  
446
Edwin Desouza
09/20/2016 09:21AM
Preparse Query Rewrite Plugin DLL  
815
Francois Haddad
08/12/2016 05:16PM
Re: Preparse Query Rewrite Plugin DLL  
299
Georgi Kodinov
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
374
Francois Haddad
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
302
Tor Didriksen
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
325
Francois Haddad
09/15/2016 11:34AM
why the two query has a different execute plan?  
737
h h
08/22/2016 02:55AM
Re: why the two query has a different execute plan?  
356
Øystein Grøvlen
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
263
Rick James
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
260
Francois Haddad
08/15/2016 09:28AM
how to optimize this sql?  
541
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
322
Peter Brawley
07/08/2016 10:59AM
Re: how to optimize this sql?  
309
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
316
Rick James
07/09/2016 11:04PM
Re: how to optimize this sql?  
296
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
435
Rick James
07/14/2016 12:52PM
Indexing for date column for range query  
588
duc minh
07/05/2016 11:04PM
Re: Indexing for date column for range query  
341
Rick James
07/09/2016 10:47PM
Help with partially unique index  
684
El T
06/22/2016 04:44AM
Re: Help with partially unique index  
335
Rick James
06/25/2016 10:45PM
Re: Help with partially unique index  
330
El T
07/02/2016 03:33PM
Re: Help with partially unique index  
301
Rick James
07/04/2016 12:50PM
Explain plans for InnoDB and Memory Engines  
675
Jagan Kumar
05/02/2016 03:15PM
Re: Explain plans for InnoDB and Memory Engines  
340
Peter Brawley
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
437
Øystein Grøvlen
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
360
Rick James
05/05/2016 10:18PM
MySQL Query Rewrite Plugins  
760
Edwin Desouza
02/02/2016 09:48PM
why left join can not use unique index?  
1,305
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
504
Rick James
12/08/2015 08:46PM
Re: why left join can not use unique index?  
501
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
495
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  
890
Michael W.
11/16/2015 11:14AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
457
Rick James
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
547
Michael W.
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
471
Rick James
12/07/2015 01:17AM
Why not use index  
1,021
zhang peng
11/08/2015 11:14PM
Re: Why not use index  
482
Peter Brawley
11/09/2015 11:42AM
Re: Why not use index  
528
zhang peng
11/11/2015 12:17AM
Re: Why not use index  
468
Øystein Grøvlen
11/10/2015 10:35AM
Re: Why not use index  
573
zhang peng
11/11/2015 12:15AM
Re: Why not use index  
481
Øystein Grøvlen
11/11/2015 03:40AM
Re: Why not use index  
661
zhang peng
11/11/2015 07:29PM
Re: Why not use index  
510
Peter Brawley
11/11/2015 11:00PM
Re: Why not use index  
475
Øystein Grøvlen
11/12/2015 01:48AM
Re: Why not use index  
524
zhang peng
11/16/2015 12:17AM
Google Update Optimizer system  
926
Anik Bhowmik
11/09/2015 09:35PM
Re: Google Update Optimizer system  
501
Peter Brawley
11/09/2015 10:12PM
Re: Google Update Optimizer system  
476
Jonathan Stephens
11/10/2015 01:02AM
Normalize dump table  
1,317
Jose Valle
10/11/2015 08:37PM
Re: Normalize dump table  
465
Jose Valle
10/11/2015 08:42PM
Re: Normalize dump table  
519
Antonio Valle
10/13/2015 01:41PM
Re: Normalize dump table  
491
Rick James
10/17/2015 07:15PM
optimize query for index using between and group by  
1,369
Raghavendra raghu
08/28/2015 03:21AM
Re: optimize query for index using between and group by  
774
Rick James
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
558
Raghavendra raghu
08/31/2015 02:34AM
Parsing in MySQL Workbench: the ANTLR age  
1,077
Edwin Desouza
08/14/2015 10:16AM
This topic has been moved.:  Improve search when using IN() ORDER BY PRIMARY and LIMIT  
0
jon sans
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.