MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster Manager 1.4.8 has been released 01/23/2020 11:50PM
•   MySQL Cluster 7.6.13 has been released 01/14/2020 04:51PM
•   MySQL Cluster 7.3.28 has been released 01/14/2020 11:48AM
•   MySQL Cluster 7.5.17 has been released 01/14/2020 05:47AM
•   MySQL Cluster 7.4.27 has been released 01/14/2020 04:24AM

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

Subject
Views
Written By
Posted
Sticky:  MySQL 8.0: Hash Join and EXPLAIN ANALYZE (1 Posts)  
93
Edwin Desouza
10/01/2019 05:40PM
Sticky:  MySQL 8.0: One Giant Leap For SQL (1 Posts)  
488
Edwin Desouza
04/25/2018 10:16AM
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
723
Edwin Desouza
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
631
Edwin Desouza
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
990
Edwin Desouza
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
1,113
Edwin Desouza
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
1,800
Edwin Desouza
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
2,504
Edwin Desouza
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
3,893
Edwin Desouza
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
4,404
Edwin Desouza
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
10,138
Edwin DeSouza
04/28/2007 06:20PM
MySQL 8.0: Simple way to figure out why your recursive CTE is running away  
23
Edwin Desouza
01/15/2020 06:06AM
optimizer seems to skip stored function call in where clause?  
54
John LeSueur
01/08/2020 11:07AM
Re: optimizer seems to skip stored function call in where clause?  
22
John LeSueur
01/08/2020 11:21AM
Re: optimizer seems to skip stored function call in where clause?  
29
Peter Brawley
01/08/2020 01:11PM
MySQL 8.0: AntiJoin  
61
Edwin Desouza
12/18/2019 07:54AM
MySQL 8.0: Hash Join  
75
Edwin Desouza
11/13/2019 12:36PM
MySQL 8.0: Understanding Hash Joins  
75
Edwin Desouza
10/30/2019 11:06AM
Explain Analyze in MySQL 8  
104
Edwin Desouza
10/28/2019 05:00PM
optimizing searches using aggregate data in join  
150
Matthew Lenz
10/21/2019 09:05AM
Re: optimizing searches using aggregate data in join  
43
Peter Brawley
10/21/2019 11:37AM
MySQL 8.0: EXPLAIN ANALYZE  
90
Edwin Desouza
10/17/2019 07:15AM
MySQL 8.0.18 Maintenance Release is Generally Available  
75
Edwin Desouza
10/14/2019 01:06PM
Slow Query  
295
Deepak Nirmul
06/21/2019 04:47AM
Re: Slow Query  
80
Peter Brawley
06/21/2019 10:17AM
Re: Slow Query  
85
Deepak Nirmul
06/24/2019 02:18AM
Re: Slow Query  
94
Peter Brawley
06/24/2019 09:56AM
Re: Slow Query  
89
Deepak Nirmul
06/24/2019 10:15AM
Re: Slow Query  
93
Peter Brawley
06/24/2019 10:45AM
Re: Slow Query  
52
Gopal venkat
09/04/2019 11:47AM
Gopal, please don't hijack threads  
54
Peter Brawley
09/04/2019 02:32PM
Re: Slow Query  
59
marimuthu B
09/06/2019 05:59AM
Re: Slow Query  
64
Peter Brawley
09/06/2019 09:57AM
MySQL 8.0: Supporting all kinds of outer references in derived tables (lateral, or not)  
135
Edwin Desouza
07/12/2019 11:13AM
setting an index for speed  
193
Michael Peters
07/02/2019 04:56AM
Re: setting an index for speed  
90
Peter Brawley
07/02/2019 12:29PM
Query optimization and indexing - Help needed  
229
Pandit P
06/13/2019 06:41AM
Re: Query optimization and indexing - Help needed  
84
Peter Brawley
06/13/2019 12:55PM
Re: Query optimization and indexing - Help needed  
83
Pandit P
06/14/2019 12:01AM
Re: Query optimization and indexing - Help needed  
83
Peter Brawley
06/14/2019 07:51AM
Is the query order guaranteed using Btree indexes and no ORDER BY  
210
Ted Johnson
05/29/2019 02:12PM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY  
90
Peter Brawley
05/29/2019 03:00PM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY  
76
Ted Johnson
05/29/2019 04:41PM
CHECK constraints in MySQL  
152
Edwin Desouza
05/14/2019 09:37AM
MySQL 8.0: Removal of implicit and explicit sorting for GROUP BY  
207
Edwin Desouza
04/10/2019 09:14AM
Comparing two columns on big table  
215
Krzysztof Wróblewski
03/21/2019 03:24PM
Re: Comparing two columns on big table  
125
Peter Brawley
03/21/2019 04:24PM
help with this query  
222
sha fendi
03/16/2019 09:17PM
Re: help with this query  
121
Peter Brawley
03/17/2019 11:04AM
MySQL Functional Indexes  
185
Edwin Desouza
03/14/2019 09:49AM
MySQL 8.0: Query analytics [CTEs, Window Functions]  
192
Edwin Desouza
03/09/2019 11:04PM
MySQL 8.0: Improvements to ROLLUP  
189
Edwin Desouza
03/05/2019 11:53AM
MySQL 8.0: Window Functions for JSON  
171
Edwin Desouza
02/21/2019 11:08AM
what's the execution order of each part of a sql query  
241
aaron chan
02/19/2019 09:00PM
Re: what's the execution order of each part of a sql query  
113
Peter Brawley
02/20/2019 10:47AM
MySQL 8.0: New Index Features  
254
Edwin Desouza
02/08/2019 11:18AM
MySQL 8.0: support for LATERAL derived tables  
224
Edwin Desouza
01/31/2019 11:07AM
MySQL 8.0: Keywords  
409
Edwin Desouza
01/10/2019 09:22PM
MySQL 8.0: Window Functions with Unusual Boundaries  
309
Edwin Desouza
11/08/2018 02:42PM
More SQL in MySQL 8.0  
564
Edwin Desouza
11/06/2018 07:28PM
MySQL 8.0: What Is New in Optimizer and Executor?  
327
Edwin Desouza
11/01/2018 11:10AM
Optimizer Improvements in MySQL 8.0  
298
Edwin Desouza
10/31/2018 09:31PM
Indexes are not working after restoring dump  
388
Amit K
09/27/2018 11:25AM
Re: Indexes are not working after restoring dump  
237
Amit K
09/27/2018 01:39PM
Re: Indexes are not working after restoring dump  
218
Amit K
09/27/2018 01:45PM
Re: Indexes are not working after restoring dump  
206
Øystein Grøvlen
09/28/2018 12:21AM
Re: Indexes are not working after restoring dump  
241
Peter Brawley
09/27/2018 07:14PM
Re: Indexes are not working after restoring dump  
226
Amit K
09/27/2018 08:31PM
Re: Indexes are not working after restoring dump  
212
Peter Brawley
09/28/2018 11:08AM
Optimizer produces incorrect resultset  
302
J Barchan
09/27/2018 09:35AM
Manipulating queries with non-conforming data via MySQL Query Rewrite Plugin, triggers and stored procedures  
330
Edwin Desouza
09/07/2018 10:34AM
Where Clause Optimization  
434
Mohammed Yehia El Sayed Abdoh
08/31/2018 06:47AM
Re: Where Clause Optimization  
214
Peter Brawley
08/31/2018 01:55PM
Re: Where Clause Optimization  
213
Mohammed Yehia El Sayed Abdoh
08/31/2018 03:08PM
Re: Where Clause Optimization  
227
Øystein Grøvlen
09/03/2018 02:45AM
long execution time of all requests, drop base  
736
Уррик Зарик
06/10/2018 06:10AM
Re: long execution time of all requests, drop base  
367
Peter Brawley
06/10/2018 12:24PM
Re: long execution time of all requests, drop base  
350
Уррик Зарик
06/10/2018 12:40PM
Re: long execution time of all requests, drop base  
380
Peter Brawley
06/10/2018 02:24PM
Re: long execution time of all requests, drop base  
401
Urri Zar
06/11/2018 12:09AM
Re: long execution time of all requests, drop base  
321
Urri Zar
06/12/2018 10:25AM
Re: long execution time of all requests, drop base  
350
Peter Brawley
06/12/2018 10:27AM
Re: long execution time of all requests, drop base  
423
Urri Zar
06/12/2018 10:34AM
Re: long execution time of all requests, drop base  
454
Peter Brawley
06/12/2018 12:00PM
Create index for Join some table in MySQL  
403
Kenny Nguyen
05/20/2018 10:51PM
Re: Create index for Join some table in MySQL  
260
Øystein Grøvlen
05/30/2018 12:50AM
Determine time taken by commit statement after insert or update statement  
504
Priya Pawar
05/07/2018 02:01AM
Re: Determine time taken by commit statement after insert or update statement  
287
Jesús Uzcanga
05/07/2018 08:43AM
Re: Determine time taken by commit statement after insert or update statement  
246
Priya Pawar
05/08/2018 12:03AM
MySQL 8.0: One Giant Leap For SQL  
308
Edwin Desouza
04/25/2018 10:14AM
how to speed up query on a table with over 20million records?  
544
li zheng
03/25/2018 07:27AM
Re: how to speed up query on a table with over 20million records?  
310
li zheng
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
261
Peter Brawley
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
311
Peter Brawley
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
279
li zheng
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
296
Peter Brawley
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
256
li zheng
03/26/2018 02:41AM
optimize range query(using between, group by and order by)  
934
Özgen Erbakan
03/20/2018 02:34AM
Re: optimize range query(using between, group by and order by)  
477
Øystein Grøvlen
03/20/2018 03:52AM
Slow DELETE-Statement since update on 5.7  
882
engram GmbH
03/19/2018 07:51AM
Re: Slow DELETE-Statement since update on 5.7  
409
Peter Brawley
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
418
Øystein Grøvlen
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
432
engram GmbH
03/20/2018 02:09AM
Optimizer choosing wrong index  
345
Daniel Kasak
03/19/2018 05:48PM
MySQL 8.0: Histograms  
340
Edwin Desouza
03/01/2018 02:27PM
Indexing a small table increases the query cost  
613
Aram Mirzadeh
02/28/2018 04:52AM
Re: Indexing a small table increases the query cost  
271
Peter Brawley
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
307
Aram Mirzadeh
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
267
Aram Mirzadeh
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
253
Peter Brawley
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
322
Øystein Grøvlen
03/01/2018 03:15AM
MySQL: Ranking techniques  
391
Edwin Desouza
01/23/2018 11:23AM
MySQL 8.0: Row numbering, ranking: using Window Functions  
407
Edwin Desouza
12/22/2017 11:41PM
My query take along time  
606
Murawweh Daher
12/17/2017 07:18AM
Muranweh, please don't double-post  
245
Peter Brawley
12/17/2017 09:48AM
MySQL 8.0: Query Optimizer Takes Data Buffering into Account  
383
Edwin Desouza
12/07/2017 11:21AM
Compound index (pkey) not used when it should be  
590
Dan Parker
11/29/2017 01:39PM
Re: Compound index (pkey) not used when it should be  
354
Peter Brawley
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
338
Dan Parker
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
326
Peter Brawley
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
328
Dan Parker
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
330
Peter Brawley
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
346
Dan Parker
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
314
Peter Brawley
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
333
Dan Parker
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
324
Peter Brawley
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
321
Dan Parker
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
323
Peter Brawley
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
312
Dan Parker
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
324
Peter Brawley
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
334
Dan Parker
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
312
Peter Brawley
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
329
Øystein Grøvlen
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
320
Dan Parker
12/01/2017 10:36AM
Confirmation on possible parser bug  
525
Patrick Meredith
11/27/2017 10:47AM
Re: Confirmation on possible parser bug  
258
Peter Brawley
11/30/2017 11:20AM
This topic has been moved.:  optimizing searches using aggregate data in join  
0
Matthew Lenz
10/21/2019 11:06AM
This topic has been moved.:  setting an index for speed  
9
Michael Peters
07/02/2019 12:26PM
This topic has been moved.:  Slow Query  
0
Deepak Nirmul
06/21/2019 10:18AM
This topic has been moved.:  help with this query  
0
sha fendi
03/17/2019 11:05AM
This topic has been moved.:  My query take along time  
0
Murawweh Daher
12/17/2017 09:37AM
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.