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

Subject
Views
Written By
Posted
93
10/01/2019 05:40PM
Sticky:  MySQL 8.0: One Giant Leap For SQL (1 Posts)  
488
04/25/2018 10:16AM
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
723
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
631
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
990
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
1,113
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
1,800
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
2,504
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
3,893
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
4,404
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
10,138
04/28/2007 06:20PM
Re: optimizer seems to skip stored function call in where clause?  
22
01/08/2020 11:21AM
Re: optimizer seems to skip stored function call in where clause?  
29
01/08/2020 01:11PM
61
12/18/2019 07:54AM
75
11/13/2019 12:36PM
104
10/28/2019 05:00PM
Re: optimizing searches using aggregate data in join  
43
10/21/2019 11:37AM
90
10/17/2019 07:15AM
295
06/21/2019 04:47AM
Re: Slow Query  
80
06/21/2019 10:17AM
Re: Slow Query  
85
06/24/2019 02:18AM
Re: Slow Query  
94
06/24/2019 09:56AM
Re: Slow Query  
89
06/24/2019 10:15AM
Re: Slow Query  
93
06/24/2019 10:45AM
Re: Slow Query  
52
09/04/2019 11:47AM
Gopal, please don't hijack threads  
54
09/04/2019 02:32PM
Re: Slow Query  
59
09/06/2019 05:59AM
Re: Slow Query  
64
09/06/2019 09:57AM
193
07/02/2019 04:56AM
Re: setting an index for speed  
90
07/02/2019 12:29PM
Re: Query optimization and indexing - Help needed  
84
06/13/2019 12:55PM
Re: Query optimization and indexing - Help needed  
83
06/14/2019 12:01AM
Re: Query optimization and indexing - Help needed  
83
06/14/2019 07:51AM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY  
90
05/29/2019 03:00PM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY  
76
05/29/2019 04:41PM
152
05/14/2019 09:37AM
Re: Comparing two columns on big table  
125
03/21/2019 04:24PM
222
03/16/2019 09:17PM
Re: help with this query  
121
03/17/2019 11:04AM
185
03/14/2019 09:49AM
Re: what's the execution order of each part of a sql query  
113
02/20/2019 10:47AM
254
02/08/2019 11:18AM
409
01/10/2019 09:22PM
564
11/06/2018 07:28PM
Re: Indexes are not working after restoring dump  
237
09/27/2018 01:39PM
Re: Indexes are not working after restoring dump  
218
09/27/2018 01:45PM
Re: Indexes are not working after restoring dump  
206
09/28/2018 12:21AM
Re: Indexes are not working after restoring dump  
241
09/27/2018 07:14PM
Re: Indexes are not working after restoring dump  
226
09/27/2018 08:31PM
Re: Indexes are not working after restoring dump  
212
09/28/2018 11:08AM
Re: Where Clause Optimization  
214
08/31/2018 01:55PM
Re: Where Clause Optimization  
213
08/31/2018 03:08PM
Re: Where Clause Optimization  
227
09/03/2018 02:45AM
Re: long execution time of all requests, drop base  
367
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
06/10/2018 02:24PM
Re: long execution time of all requests, drop base  
401
06/11/2018 12:09AM
Re: long execution time of all requests, drop base  
321
06/12/2018 10:25AM
Re: long execution time of all requests, drop base  
350
06/12/2018 10:27AM
Re: long execution time of all requests, drop base  
423
06/12/2018 10:34AM
Re: long execution time of all requests, drop base  
454
06/12/2018 12:00PM
Re: Create index for Join some table in MySQL  
260
05/30/2018 12:50AM
Re: Determine time taken by commit statement after insert or update statement  
287
05/07/2018 08:43AM
Re: Determine time taken by commit statement after insert or update statement  
246
05/08/2018 12:03AM
Re: how to speed up query on a table with over 20million records?  
310
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
261
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
311
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
279
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
296
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
256
03/26/2018 02:41AM
Re: optimize range query(using between, group by and order by)  
477
03/20/2018 03:52AM
Re: Slow DELETE-Statement since update on 5.7  
409
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
418
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
432
03/20/2018 02:09AM
345
03/19/2018 05:48PM
340
03/01/2018 02:27PM
Re: Indexing a small table increases the query cost  
271
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
307
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
267
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
253
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
322
03/01/2018 03:15AM
391
01/23/2018 11:23AM
606
12/17/2017 07:18AM
Muranweh, please don't double-post  
245
12/17/2017 09:48AM
Re: Compound index (pkey) not used when it should be  
354
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
338
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
326
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
328
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
330
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
346
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
314
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
333
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
324
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
321
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
323
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
312
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
324
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
334
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
312
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
329
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
320
12/01/2017 10:36AM
Re: Confirmation on possible parser bug  
258
11/30/2017 11:20AM
This topic has been moved.:  optimizing searches using aggregate data in join  
0
10/21/2019 11:06AM
This topic has been moved.:  setting an index for speed  
9
07/02/2019 12:26PM
This topic has been moved.:  Slow Query  
0
06/21/2019 10:18AM
This topic has been moved.:  help with this query  
0
03/17/2019 11:05AM
This topic has been moved.:  My query take along time  
0
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.