MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing July 2024 off-cycle Releases featuring MySQL Server 9.0.1 Innovation, 8.4.2 LTS and 8.0.39 07/24/2024 11:15AM
•   Announcing July 2024 Releases featuring MySQL Server 9.0.0 Innovation, 8.4.1 LTS and 8.0.38 07/02/2024 06:42AM

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

Subject
Views
Written By
Posted
MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance  
1,247
Edwin Desouza
05/23/2017 11:01AM
MySQL Index Advisor for SQL Tuning  
4,842
Chaitanya Challa
05/10/2017 09:12PM
Re: MySQL Index Advisor for SQL Tuning  
2,894
Edwin Desouza
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
1,682
Chaitanya Challa
05/11/2017 08:08AM
MySQL 8.0: CTEs Recursive Query Throwdown  
1,534
Edwin Desouza
05/05/2017 06:14PM
MySQL 8.0: GROUPING function  
743
Edwin Desouza
05/02/2017 10:37AM
How to Analyze and Tune MySQL Queries for Better Performance  
745
Edwin Desouza
04/27/2017 11:32AM
MySQL 8.0: Optimizer: What's New  
841
Edwin Desouza
04/27/2017 11:31AM
MySQL 8.0 Optimizer Guide  
904
Edwin Desouza
04/27/2017 11:30AM
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows  
900
Edwin Desouza
04/12/2017 11:57AM
MySQL 8.0: Improved performance with CTE  
893
Edwin Desouza
04/12/2017 11:57AM
MySQL 5.7: What to Do When the Optimizer Overestimates the Condition Filtering Effect  
790
Edwin Desouza
03/24/2017 11:30AM
prepare don't work for optimize statement  
1,019
Long WU
03/22/2017 12:30AM
Re: prepare don't work for optimize statement  
537
Øystein Grøvlen
03/22/2017 01:34AM
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account  
949
Edwin Desouza
03/17/2017 02:49PM
Improve search when using IN() ORDER BY PRIMARY and LIMIT  
1,348
jon sans
02/11/2017 07:17AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
493
jon sans
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
593
Øystein Grøvlen
02/13/2017 05:58AM
MySQL Performance Tuning: Optimizer Hints  
842
Edwin Desouza
02/04/2017 09:09PM
Hiw to fast delete rows from table in relation?  
1,145
Andrzej Borucki
01/22/2017 02:21AM
Re: Hiw to fast delete rows from table in relation?  
653
Andrzej Borucki
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
584
Andrzej Borucki
01/22/2017 04:03AM
Query not always using indexes  
2,622
K DBA
01/06/2017 05:48AM
Re: Query not always using indexes  
849
Peter Brawley
01/06/2017 12:28PM
Re: Query not always using indexes  
983
K DBA
01/09/2017 05:18AM
Re: Query not always using indexes  
840
Øystein Grøvlen
01/09/2017 02:30AM
Optimize subquery, replace IN() with JOIN  
2,299
Miron jajtic
11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN  
928
Peter Brawley
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
1,060
Miron jajtic
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
904
Rick James
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
888
Peter Brawley
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
889
Miron jajtic
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
924
Peter Brawley
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
1,019
Miron jajtic
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
877
Peter Brawley
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
683
sahar gull
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
780
Øystein Grøvlen
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
825
Miron jajtic
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
969
Øystein Grøvlen
11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery  
892
Edwin Desouza
12/23/2016 08:50AM
primary key vs covered index  
1,382
marcin kot
11/30/2016 09:55AM
Re: primary key vs covered index  
754
Øystein Grøvlen
12/01/2016 01:39AM
Re: primary key vs covered index  
732
marcin kot
12/01/2016 03:38AM
Re: primary key vs covered index  
776
Øystein Grøvlen
12/01/2016 03:57AM
Re: primary key vs covered index  
678
marcin kot
12/01/2016 04:16AM
Re: primary key vs covered index  
651
Øystein Grøvlen
12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser  
990
Edwin Desouza
11/22/2016 10:58AM
MySQL subquery  
1,232
harry sheng
10/27/2016 02:51PM
Re: MySQL subquery  
771
Øystein Grøvlen
10/28/2016 01:03AM
Re: MySQL subquery  
758
harry sheng
11/06/2016 08:50PM
Re: MySQL subquery  
763
Øystein Grøvlen
11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance  
1,041
Edwin Desouza
10/21/2016 09:58AM
Index on timestamp  
7,912
Adeline M
10/14/2016 08:47AM
Re: Index on timestamp  
3,206
Rick James
10/16/2016 04:40PM
MySQL 8.0: Descending Indexes  
1,243
Edwin Desouza
10/12/2016 10:00AM
Pivot table with dynamic columns  
6,717
Aram Mirzadeh
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
2,538
Rick James
10/03/2016 03:40PM
inner join vs left join - huge performance difference  
12,374
michael cook
07/06/2016 09:32AM
Re: inner join vs left join - huge performance difference  
2,986
Peter Brawley
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
2,004
michael cook
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
1,649
michael cook
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
1,435
Peter Brawley
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
1,495
michael cook
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
1,472
michael cook
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
1,473
Peter Brawley
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
1,202
michael cook
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
1,322
Rick James
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
1,478
Peter Brawley
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
1,628
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  
1,265
Edwin Desouza
09/20/2016 09:21AM
Preparse Query Rewrite Plugin DLL  
2,143
Francois Haddad
08/12/2016 05:16PM
Re: Preparse Query Rewrite Plugin DLL  
805
Georgi Kodinov
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
1,183
Francois Haddad
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
888
Tor Didriksen
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
1,029
Francois Haddad
09/15/2016 11:34AM
Preparse Query Rewrite Plugin DLL  
1,810
Francois Haddad
06/03/2016 12:41PM
Re: Preparse Query Rewrite Plugin DLL  
725
Francois Haddad
06/03/2016 03:13PM
Re: Preparse Query Rewrite Plugin DLL  
725
Georgi Kodinov
06/28/2016 02:12AM
Re: Preparse Query Rewrite Plugin DLL  
712
Francois Haddad
08/12/2016 05:13PM
why the two query has a different execute plan?  
2,461
h h
08/22/2016 02:55AM
Re: why the two query has a different execute plan?  
769
Øystein Grøvlen
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
720
Rick James
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
693
Francois Haddad
08/15/2016 09:28AM
how to optimize this sql?  
1,412
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
1,003
Peter Brawley
07/08/2016 10:59AM
Re: how to optimize this sql?  
966
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
882
Rick James
07/09/2016 11:04PM
Re: how to optimize this sql?  
884
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
834
Rick James
07/14/2016 12:52PM
Indexing for date column for range query  
1,278
duc minh
07/05/2016 11:04PM
Re: Indexing for date column for range query  
753
Rick James
07/09/2016 10:47PM
Help with partially unique index  
1,427
El T
06/22/2016 04:44AM
Re: Help with partially unique index  
880
Rick James
06/25/2016 10:45PM
Re: Help with partially unique index  
936
El T
07/02/2016 03:33PM
Re: Help with partially unique index  
738
Rick James
07/04/2016 12:50PM
Explain plans for InnoDB and Memory Engines  
1,468
Jagan Kumar
05/02/2016 03:15PM
Re: Explain plans for InnoDB and Memory Engines  
737
Peter Brawley
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
897
Øystein Grøvlen
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
809
Rick James
05/05/2016 10:18PM
MySQL Query Rewrite Plugins  
1,249
Edwin Desouza
02/02/2016 09:48PM
why left join can not use unique index?  
2,434
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
1,014
Rick James
12/08/2015 08:46PM
Re: why left join can not use unique index?  
897
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
924
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  
1,478
Michael W.
11/16/2015 11:14AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
935
Rick James
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
988
Michael W.
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
1,001
Rick James
12/07/2015 01:17AM
Why not use index  
1,698
zhang peng
11/08/2015 11:14PM
Re: Why not use index  
860
Peter Brawley
11/09/2015 11:42AM
Re: Why not use index  
869
zhang peng
11/11/2015 12:17AM
Re: Why not use index  
902
Øystein Grøvlen
11/10/2015 10:35AM
Re: Why not use index  
1,055
zhang peng
11/11/2015 12:15AM
Re: Why not use index  
944
Øystein Grøvlen
11/11/2015 03:40AM
Re: Why not use index  
1,200
zhang peng
11/11/2015 07:29PM
Re: Why not use index  
837
Peter Brawley
11/11/2015 11:00PM
Re: Why not use index  
932
Øystein Grøvlen
11/12/2015 01:48AM
Re: Why not use index  
899
zhang peng
11/16/2015 12:17AM
Google Update Optimizer system  
1,554
Anik Bhowmik
11/09/2015 09:35PM
Re: Google Update Optimizer system  
932
Peter Brawley
11/09/2015 10:12PM
Re: Google Update Optimizer system  
834
Jonathan Stephens
11/10/2015 01:02AM
Normalize dump table  
2,476
Jose Valle
10/11/2015 08:37PM
Re: Normalize dump table  
879
Jose Valle
10/11/2015 08:42PM
Re: Normalize dump table  
1,099
Antonio Valle
10/13/2015 01:41PM
Re: Normalize dump table  
982
Rick James
10/17/2015 07:15PM
optimize query for index using between and group by  
2,537
Raghavendra raghu
08/28/2015 03:21AM
Re: optimize query for index using between and group by  
1,460
Rick James
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
951
Raghavendra raghu
08/31/2015 02:34AM
Parsing in MySQL Workbench: the ANTLR age  
1,799
Edwin Desouza
08/14/2015 10:16AM
MySQL Optimizer: Hints  
1,779
Edwin Desouza
07/29/2015 10:07AM
Index not working for date field used in between query  
5,366
Shrinivasa rao
07/22/2015 11:48PM
Re: Index not working for date field used in between query  
2,062
Rick James
07/26/2015 08:28AM
MyISAM using 'wrong' index  
1,874
Danny Stommen
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
1,049
Rick James
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
1,603
Danny Stommen
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
1,247
Rick James
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
1,095
Danny Stommen
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
1,140
Rick James
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
1,063
Danny Stommen
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
966
Edwin Desouza
07/07/2015 09:10AM
Need help understanding optimizer behavior in 5.6  
2,240
Aaron Craven
06/22/2015 08:30AM
Re: Need help understanding optimizer behavior in 5.6  
1,096
Aaron Craven
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
1,109
Rick James
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
1,090
Aaron Craven
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
1,068
Rick James
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
1,107
Aaron Craven
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
1,076
Øystein Grøvlen
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
1,588
Aaron Craven
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
1,062
Aaron Craven
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
1,252
Øystein Grøvlen
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
1,240
Aaron Craven
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
1,086
Edwin Desouza
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
1,140
Aaron Craven
07/02/2015 07:48AM
MySQL 5.7: Optimizer Trace and EXPLAIN FORMAT=JSON  
2,215
Edwin Desouza
05/25/2015 10:41AM
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
...
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.