MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/J 5.1.47 GA has been released 08/17/2018 11:50AM
•   MySQL Connector/NET 6.10.8 has been released 08/15/2018 12:29AM
•   MySQL Connector/ODBC 5.3.11 has been released 07/30/2018 01:00PM
•   MySQL Shell 8.0.12 for MySQL Server 8.0 and 5.7 has been released 07/27/2018 04:33PM
•   MySQL Cluster 7.3.22 has been released 07/27/2018 02:45PM

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

Subject
Views
Written By
Posted
Sticky:  MySQL 8.0: One Giant Leap For SQL (1 Posts)  
117
Edwin Desouza
04/25/2018 10:16AM
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
412
Edwin Desouza
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
401
Edwin Desouza
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
713
Edwin Desouza
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
719
Edwin Desouza
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
1,506
Edwin Desouza
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
2,192
Edwin Desouza
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
3,620
Edwin Desouza
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
4,123
Edwin Desouza
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
9,745
Edwin DeSouza
04/28/2007 06:20PM
long execution time of all requests, drop base  
121
Уррик Зарик
06/10/2018 06:10AM
Re: long execution time of all requests, drop base  
35
Peter Brawley
06/10/2018 12:24PM
Re: long execution time of all requests, drop base  
25
Уррик Зарик
06/10/2018 12:40PM
Re: long execution time of all requests, drop base  
36
Peter Brawley
06/10/2018 02:24PM
Re: long execution time of all requests, drop base  
10
Urri Zar
06/11/2018 12:09AM
Re: long execution time of all requests, drop base  
23
Urri Zar
06/12/2018 10:25AM
Re: long execution time of all requests, drop base  
20
Peter Brawley
06/12/2018 10:27AM
Re: long execution time of all requests, drop base  
25
Urri Zar
06/12/2018 10:34AM
Re: long execution time of all requests, drop base  
34
Peter Brawley
06/12/2018 12:00PM
Create index for Join some table in MySQL  
65
Kenny Nguyen
05/20/2018 10:51PM
Re: Create index for Join some table in MySQL  
38
Øystein Grøvlen
05/30/2018 12:50AM
Determine time taken by commit statement after insert or update statement  
87
Priya Pawar
05/07/2018 02:01AM
Re: Determine time taken by commit statement after insert or update statement  
49
Jesús Uzcanga
05/07/2018 08:43AM
Re: Determine time taken by commit statement after insert or update statement  
45
Priya Pawar
05/08/2018 12:03AM
MySQL 8.0: One Giant Leap For SQL  
59
Edwin Desouza
04/25/2018 10:14AM
how to speed up query on a table with over 20million records?  
122
li zheng
03/25/2018 07:27AM
Re: how to speed up query on a table with over 20million records?  
64
li zheng
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
65
Peter Brawley
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
64
Peter Brawley
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
52
li zheng
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
57
Peter Brawley
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
62
li zheng
03/26/2018 02:41AM
optimize range query(using between, group by and order by)  
173
Özgen Erbakan
03/20/2018 02:34AM
Re: optimize range query(using between, group by and order by)  
150
Øystein Grøvlen
03/20/2018 03:52AM
Slow DELETE-Statement since update on 5.7  
156
engram GmbH
03/19/2018 07:51AM
Re: Slow DELETE-Statement since update on 5.7  
62
Peter Brawley
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
72
Øystein Grøvlen
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
108
engram GmbH
03/20/2018 02:09AM
Optimizer choosing wrong index  
8
Daniel Kasak
03/19/2018 05:48PM
MySQL 8.0: Histograms  
95
Edwin Desouza
03/01/2018 02:27PM
Indexing a small table increases the query cost  
118
Aram Mirzadeh
02/28/2018 04:52AM
Re: Indexing a small table increases the query cost  
51
Peter Brawley
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
54
Aram Mirzadeh
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
56
Aram Mirzadeh
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
52
Peter Brawley
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
76
Øystein Grøvlen
03/01/2018 03:15AM
MySQL: Ranking techniques  
120
Edwin Desouza
01/23/2018 11:23AM
MySQL 8.0: Row numbering, ranking: using Window Functions  
141
Edwin Desouza
12/22/2017 11:41PM
My query take along time  
193
Murawweh Daher
12/17/2017 07:18AM
Muranweh, please don't double-post  
67
Peter Brawley
12/17/2017 09:48AM
MySQL 8.0: Query Optimizer Takes Data Buffering into Account  
111
Edwin Desouza
12/07/2017 11:21AM
Compound index (pkey) not used when it should be  
170
Dan Parker
11/29/2017 01:39PM
Re: Compound index (pkey) not used when it should be  
103
Peter Brawley
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
91
Dan Parker
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
91
Peter Brawley
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
97
Dan Parker
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
89
Peter Brawley
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
102
Dan Parker
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
83
Peter Brawley
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
81
Dan Parker
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
76
Peter Brawley
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
76
Dan Parker
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
80
Peter Brawley
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
80
Dan Parker
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
80
Peter Brawley
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
86
Dan Parker
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
73
Peter Brawley
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
78
Øystein Grøvlen
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
76
Dan Parker
12/01/2017 10:36AM
Confirmation on possible parser bug  
175
Patrick Meredith
11/27/2017 10:47AM
Re: Confirmation on possible parser bug  
81
Peter Brawley
11/30/2017 11:20AM
Source code question related to sql_optimizer.cc line 8583  
181
Petru-Florin Mihancea
11/28/2017 04:20AM
Re: Source code question related to sql_optimizer.cc line 8583  
82
Øystein Grøvlen
11/28/2017 07:01AM
MySQL 8.0: Optimization to skip index dives with FORCE INDEX.  
238
Edwin Desouza
11/17/2017 09:50AM
Is Union Queries run in Parallel form or not.  
267
Azeem Haider
10/17/2017 11:40PM
Re: Is Union Queries run in Parallel form or not.  
127
Peter Brawley
10/18/2017 08:32AM
Re: Is Union Queries run in Parallel form or not.  
131
Azeem Haider
10/18/2017 10:43PM
Re: Is Union Queries run in Parallel form or not.  
108
Peter Brawley
10/18/2017 10:55PM
Re: Is Union Queries run in Parallel form or not.  
160
Øystein Grøvlen
10/19/2017 03:02AM
MySQL 8.0: Window Functions  
160
Edwin Desouza
10/04/2017 06:03PM
Grammer Rule for Parenthesis in Select Statement  
303
Sushant Choudhary
09/21/2017 12:47PM
Please don't duplicate posts  
142
Peter Brawley
09/21/2017 12:49PM
Help with explain on query  
272
Alex Titley
08/16/2017 09:09AM
Re: Help with explain on query  
118
Peter Brawley
08/16/2017 10:07AM
Optimizer Stablility  
228
Chris Reston
08/16/2017 12:56AM
Re: Optimizer Stablility  
138
Øystein Grøvlen
08/16/2017 02:19AM
Way to avoid fragmentation of MySQL tables  
228
Priya Pawar
07/30/2017 11:01AM
Re: Way to avoid fragmentation of MySQL tables  
139
Peter Brawley
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
124
Priya Pawar
07/30/2017 11:10PM
MySQL 8.0.2: Introducing Window Functions  
223
Edwin Desouza
07/18/2017 10:33AM
Can anyone help speed up this query?  
290
Search Team
06/21/2017 11:07AM
Re: Can anyone help speed up this query?  
167
Peter Brawley
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
153
Search Team
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
183
Peter Brawley
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
141
Search Team
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
135
Peter Brawley
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
139
Øystein Grøvlen
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
155
Search Team
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
138
Øystein Grøvlen
06/23/2017 12:53AM
Is there a better ANTLR grammar file for MySQL ?  
570
Bill Nicholson
05/28/2017 05:07PM
Re: Is there a better ANTLR grammar file for MySQL ?  
254
Edwin Desouza
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
231
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  
357
Edwin Desouza
05/23/2017 11:01AM
MySQL Index Advisor for SQL Tuning  
995
Chaitanya Challa
05/10/2017 09:12PM
Re: MySQL Index Advisor for SQL Tuning  
643
Edwin Desouza
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
405
Chaitanya Challa
05/11/2017 08:08AM
MySQL 8.0: CTEs Recursive Query Throwdown  
343
Edwin Desouza
05/05/2017 06:14PM
MySQL 8.0: GROUPING function  
256
Edwin Desouza
05/02/2017 10:37AM
How to Analyze and Tune MySQL Queries for Better Performance  
287
Edwin Desouza
04/27/2017 11:32AM
MySQL 8.0: Optimizer: What's New  
323
Edwin Desouza
04/27/2017 11:31AM
MySQL 8.0 Optimizer Guide  
366
Edwin Desouza
04/27/2017 11:30AM
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows  
340
Edwin Desouza
04/12/2017 11:57AM
MySQL 8.0: Improved performance with CTE  
304
Edwin Desouza
04/12/2017 11:57AM
MySQL 5.7: What to Do When the Optimizer Overestimates the Condition Filtering Effect  
310
Edwin Desouza
03/24/2017 11:30AM
prepare don't work for optimize statement  
414
Long WU
03/22/2017 12:30AM
Re: prepare don't work for optimize statement  
164
Øystein Grøvlen
03/22/2017 01:34AM
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account  
385
Edwin Desouza
03/17/2017 02:49PM
Improve search when using IN() ORDER BY PRIMARY and LIMIT  
535
jon sans
02/11/2017 07:17AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
177
jon sans
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
200
Øystein Grøvlen
02/13/2017 05:58AM
MySQL Performance Tuning: Optimizer Hints  
336
Edwin Desouza
02/04/2017 09:09PM
Hiw to fast delete rows from table in relation?  
443
Andrzej Borucki
01/22/2017 02:21AM
Re: Hiw to fast delete rows from table in relation?  
235
Andrzej Borucki
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
241
Andrzej Borucki
01/22/2017 04:03AM
Query not always using indexes  
649
K DBA
01/06/2017 05:48AM
Re: Query not always using indexes  
279
Peter Brawley
01/06/2017 12:28PM
Re: Query not always using indexes  
353
K DBA
01/09/2017 05:18AM
Re: Query not always using indexes  
343
Øystein Grøvlen
01/09/2017 02:30AM
Optimize subquery, replace IN() with JOIN  
710
Miron jajtic
11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN  
350
Peter Brawley
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
371
Miron jajtic
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
421
Rick James
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
342
Peter Brawley
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
397
Miron jajtic
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
356
Peter Brawley
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
403
Miron jajtic
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
366
Peter Brawley
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
311
sahar gull
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
352
Øystein Grøvlen
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
345
Miron jajtic
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
395
Øystein Grøvlen
11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery  
481
Edwin Desouza
12/23/2016 08:50AM
primary key vs covered index  
665
marcin kot
11/30/2016 09:55AM
Re: primary key vs covered index  
342
Øystein Grøvlen
12/01/2016 01:39AM
Re: primary key vs covered index  
355
marcin kot
12/01/2016 03:38AM
Re: primary key vs covered index  
366
Øystein Grøvlen
12/01/2016 03:57AM
Re: primary key vs covered index  
369
marcin kot
12/01/2016 04:16AM
Re: primary key vs covered index  
325
Øystein Grøvlen
12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser  
581
Edwin Desouza
11/22/2016 10:58AM
MySQL subquery  
647
harry sheng
10/27/2016 02:51PM
Re: MySQL subquery  
333
Øystein Grøvlen
10/28/2016 01:03AM
Re: MySQL subquery  
370
harry sheng
11/06/2016 08:50PM
Re: MySQL subquery  
394
Øystein Grøvlen
11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance  
549
Edwin Desouza
10/21/2016 09:58AM
Index on timestamp  
2,362
Adeline M
10/14/2016 08:47AM
Re: Index on timestamp  
1,084
Rick James
10/16/2016 04:40PM
This topic has been moved.:  My query take along time  
0
Murawweh Daher
12/17/2017 09:37AM
This topic has been moved.:  Is Union Queries run in Parallel form or not.  
0
Azeem Haider
10/18/2017 10:56PM
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
...
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.