MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing April 2026 Releases featuring MySQL Server 9.7.0, 8.4.9 and 8.0.46 04/27/2026 03:22AM

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

Subject
Views
Written By
Posted
Query optimization and indexing - Help needed  
1,488
Pandit P
06/13/2019 06:41AM
Re: Query optimization and indexing - Help needed  
643
Peter Brawley
06/13/2019 12:55PM
Re: Query optimization and indexing - Help needed  
650
Pandit P
06/14/2019 12:01AM
Re: Query optimization and indexing - Help needed  
693
Peter Brawley
06/14/2019 07:51AM
Is the query order guaranteed using Btree indexes and no ORDER BY  
1,948
Ted Johnson
05/29/2019 02:12PM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY  
700
Peter Brawley
05/29/2019 03:00PM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY  
696
Ted Johnson
05/29/2019 04:41PM
CHECK constraints in MySQL  
1,176
Edwin Desouza
05/14/2019 09:37AM
MySQL 8.0: Removal of implicit and explicit sorting for GROUP BY  
1,210
Edwin Desouza
04/10/2019 09:14AM
Comparing two columns on big table  
2,337
Krzysztof Wróblewski
03/21/2019 03:24PM
Re: Comparing two columns on big table  
851
Peter Brawley
03/21/2019 04:24PM
help with this query  
1,290
sha fendi
03/16/2019 09:17PM
Re: help with this query  
723
Peter Brawley
03/17/2019 11:04AM
MySQL Functional Indexes  
1,019
Edwin Desouza
03/14/2019 09:49AM
MySQL 8.0: Query analytics [CTEs, Window Functions]  
1,050
Edwin Desouza
03/09/2019 11:04PM
MySQL 8.0: Improvements to ROLLUP  
1,075
Edwin Desouza
03/05/2019 11:53AM
MySQL 8.0: Window Functions for JSON  
953
Edwin Desouza
02/21/2019 11:08AM
what's the execution order of each part of a sql query  
1,378
aaron chan
02/19/2019 09:00PM
Re: what's the execution order of each part of a sql query  
642
Peter Brawley
02/20/2019 10:47AM
MySQL 8.0: New Index Features  
1,112
Edwin Desouza
02/08/2019 11:18AM
MySQL 8.0: support for LATERAL derived tables  
1,192
Edwin Desouza
01/31/2019 11:07AM
MySQL 8.0: Keywords  
1,492
Edwin Desouza
01/10/2019 09:22PM
I Need Help To Write Queries  
818
Mostafa Baghi
12/17/2018 04:40AM
MySQL 8.0: Window Functions with Unusual Boundaries  
1,121
Edwin Desouza
11/08/2018 02:42PM
More SQL in MySQL 8.0  
1,496
Edwin Desouza
11/06/2018 07:28PM
MySQL 8.0: What Is New in Optimizer and Executor?  
1,094
Edwin Desouza
11/01/2018 11:10AM
Optimizer Improvements in MySQL 8.0  
1,125
Edwin Desouza
10/31/2018 09:31PM
Indexes are not working after restoring dump  
1,976
Amit K
09/27/2018 11:25AM
Re: Indexes are not working after restoring dump  
1,100
Amit K
09/27/2018 01:39PM
Re: Indexes are not working after restoring dump  
872
Amit K
09/27/2018 01:45PM
Re: Indexes are not working after restoring dump  
988
Øystein Grøvlen
09/28/2018 12:21AM
Re: Indexes are not working after restoring dump  
889
Peter Brawley
09/27/2018 07:14PM
Re: Indexes are not working after restoring dump  
827
Amit K
09/27/2018 08:31PM
Re: Indexes are not working after restoring dump  
834
Peter Brawley
09/28/2018 11:08AM
Optimizer produces incorrect resultset  
1,162
J Barchan
09/27/2018 09:35AM
Manipulating queries with non-conforming data via MySQL Query Rewrite Plugin, triggers and stored procedures  
1,027
Edwin Desouza
09/07/2018 10:34AM
Where Clause Optimization  
1,277
Mohammed Yehia El Sayed Abdoh
08/31/2018 06:47AM
Re: Where Clause Optimization  
652
Peter Brawley
08/31/2018 01:55PM
Re: Where Clause Optimization  
691
Mohammed Yehia El Sayed Abdoh
08/31/2018 03:08PM
Re: Where Clause Optimization  
730
Øystein Grøvlen
09/03/2018 02:45AM
long execution time of all requests, drop base  
1,798
Уррик Зарик
06/10/2018 06:10AM
Re: long execution time of all requests, drop base  
887
Peter Brawley
06/10/2018 12:24PM
Re: long execution time of all requests, drop base  
861
Уррик Зарик
06/10/2018 12:40PM
Re: long execution time of all requests, drop base  
885
Peter Brawley
06/10/2018 02:24PM
Re: long execution time of all requests, drop base  
907
Urri Zar
06/11/2018 12:09AM
Re: long execution time of all requests, drop base  
709
Urri Zar
06/12/2018 10:25AM
Re: long execution time of all requests, drop base  
876
Peter Brawley
06/12/2018 10:27AM
Re: long execution time of all requests, drop base  
1,234
Urri Zar
06/12/2018 10:34AM
Re: long execution time of all requests, drop base  
984
Peter Brawley
06/12/2018 12:00PM
Create index for Join some table in MySQL  
1,411
Kenny Nguyen
05/20/2018 10:51PM
Re: Create index for Join some table in MySQL  
671
Øystein Grøvlen
05/30/2018 12:50AM
Determine time taken by commit statement after insert or update statement  
1,357
Priya Pawar
05/07/2018 02:01AM
Re: Determine time taken by commit statement after insert or update statement  
873
Jesús Uzcanga
05/07/2018 08:43AM
Re: Determine time taken by commit statement after insert or update statement  
655
Priya Pawar
05/08/2018 12:03AM
MySQL 8.0: One Giant Leap For SQL  
966
Edwin Desouza
04/25/2018 10:14AM
how to speed up query on a table with over 20million records?  
1,783
li zheng
03/25/2018 07:27AM
Re: how to speed up query on a table with over 20million records?  
913
li zheng
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
792
Peter Brawley
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
881
Peter Brawley
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
851
li zheng
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
931
Peter Brawley
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
762
li zheng
03/26/2018 02:41AM
optimize range query(using between, group by and order by)  
2,217
Özgen Erbakan
03/20/2018 02:34AM
Re: optimize range query(using between, group by and order by)  
950
Øystein Grøvlen
03/20/2018 03:52AM
Slow DELETE-Statement since update on 5.7  
2,442
engram GmbH
03/19/2018 07:51AM
Re: Slow DELETE-Statement since update on 5.7  
987
Peter Brawley
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
1,174
Øystein Grøvlen
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
1,176
engram GmbH
03/20/2018 02:09AM
Optimizer choosing wrong index  
1,100
Daniel Kasak
03/19/2018 05:48PM
MySQL 8.0: Histograms  
978
Edwin Desouza
03/01/2018 02:27PM
Indexing a small table increases the query cost  
1,657
Aram Mirzadeh
02/28/2018 04:52AM
Re: Indexing a small table increases the query cost  
694
Peter Brawley
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
846
Aram Mirzadeh
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
712
Aram Mirzadeh
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
662
Peter Brawley
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
934
Øystein Grøvlen
03/01/2018 03:15AM
MySQL: Ranking techniques  
1,088
Edwin Desouza
01/23/2018 11:23AM
MySQL 8.0: Row numbering, ranking: using Window Functions  
1,072
Edwin Desouza
12/22/2017 11:41PM
My query take along time  
1,461
Murawweh Daher
12/17/2017 07:18AM
Muranweh, please don't double-post  
597
Peter Brawley
12/17/2017 09:48AM
MySQL 8.0: Query Optimizer Takes Data Buffering into Account  
1,002
Edwin Desouza
12/07/2017 11:21AM
Compound index (pkey) not used when it should be  
1,589
Dan Parker
11/29/2017 01:39PM
Re: Compound index (pkey) not used when it should be  
809
Peter Brawley
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
839
Dan Parker
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
794
Peter Brawley
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
896
Dan Parker
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
790
Peter Brawley
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
877
Dan Parker
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
956
Peter Brawley
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
912
Dan Parker
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
826
Peter Brawley
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
795
Dan Parker
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
889
Peter Brawley
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
920
Dan Parker
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
813
Peter Brawley
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
870
Dan Parker
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
839
Peter Brawley
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
896
Øystein Grøvlen
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
899
Dan Parker
12/01/2017 10:36AM
Confirmation on possible parser bug  
1,204
Patrick Meredith
11/27/2017 10:47AM
Re: Confirmation on possible parser bug  
626
Peter Brawley
11/30/2017 11:20AM
Source code question related to sql_optimizer.cc line 8583  
1,403
Petru-Florin Mihancea
11/28/2017 04:20AM
Re: Source code question related to sql_optimizer.cc line 8583  
709
Øystein Grøvlen
11/28/2017 07:01AM
MySQL 8.0: Optimization to skip index dives with FORCE INDEX.  
1,164
Edwin Desouza
11/17/2017 09:50AM
Is Union Queries run in Parallel form or not.  
1,741
Azeem Haider
10/17/2017 11:40PM
Re: Is Union Queries run in Parallel form or not.  
944
Peter Brawley
10/18/2017 08:32AM
Re: Is Union Queries run in Parallel form or not.  
1,291
Azeem Haider
10/18/2017 10:43PM
Re: Is Union Queries run in Parallel form or not.  
856
Peter Brawley
10/18/2017 10:55PM
Re: Is Union Queries run in Parallel form or not.  
1,066
Øystein Grøvlen
10/19/2017 03:02AM
MySQL 8.0: Window Functions  
1,090
Edwin Desouza
10/04/2017 06:03PM
Grammer Rule for Parenthesis in Select Statement  
1,286
Sushant Choudhary
09/21/2017 12:47PM
Please don't duplicate posts  
717
Peter Brawley
09/21/2017 12:49PM
Help with explain on query  
1,192
Alex Titley
08/16/2017 09:09AM
Re: Help with explain on query  
633
Peter Brawley
08/16/2017 10:07AM
Optimizer Stablility  
1,198
Chris Reston
08/16/2017 12:56AM
Re: Optimizer Stablility  
728
Øystein Grøvlen
08/16/2017 02:19AM
Way to avoid fragmentation of MySQL tables  
1,144
Priya Pawar
07/30/2017 11:01AM
Re: Way to avoid fragmentation of MySQL tables  
902
Peter Brawley
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
686
Priya Pawar
07/30/2017 11:10PM
MySQL 8.0.2: Introducing Window Functions  
1,149
Edwin Desouza
07/18/2017 10:33AM
Can anyone help speed up this query?  
1,339
Search Team
06/21/2017 11:07AM
Re: Can anyone help speed up this query?  
844
Peter Brawley
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
852
Search Team
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
788
Peter Brawley
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
818
Search Team
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
745
Peter Brawley
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
778
Øystein Grøvlen
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
837
Search Team
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
818
Øystein Grøvlen
06/23/2017 12:53AM
Is there a better ANTLR grammar file for MySQL ?  
4,529
Bill Nicholson
05/28/2017 05:07PM
Re: Is there a better ANTLR grammar file for MySQL ?  
1,410
Edwin Desouza
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
1,249
Edwin Desouza
05/30/2017 07:57AM
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
This topic has been moved.:  Is Union Queries run in Parallel form or not.  
0
Azeem Haider
10/18/2017 10:56PM
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.