MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing April 2024 Releases featuring MySQL 8.4.0 and 8.0.37 04/30/2024 02:33PM

Subject
Views
Written By
Posted
Re: MySQL Index Advisor for SQL Tuning  
2,854
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
1,659
05/11/2017 08:08AM
733
05/02/2017 10:37AM
891
04/27/2017 11:30AM
Re: prepare don't work for optimize statement  
522
03/22/2017 01:34AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
484
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
585
02/13/2017 05:58AM
Re: Hiw to fast delete rows from table in relation?  
646
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
574
01/22/2017 04:03AM
2,556
01/06/2017 05:48AM
Re: Query not always using indexes  
840
01/06/2017 12:28PM
Re: Query not always using indexes  
941
01/09/2017 05:18AM
Re: Query not always using indexes  
831
01/09/2017 02:30AM
Re: Optimize subquery, replace IN() with JOIN  
907
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
1,025
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
888
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
822
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
876
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
884
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
1,002
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
842
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
620
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
762
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
797
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
948
11/16/2016 06:23AM
1,362
11/30/2016 09:55AM
Re: primary key vs covered index  
746
12/01/2016 01:39AM
Re: primary key vs covered index  
725
12/01/2016 03:38AM
Re: primary key vs covered index  
765
12/01/2016 03:57AM
Re: primary key vs covered index  
667
12/01/2016 04:16AM
Re: primary key vs covered index  
629
12/01/2016 04:25AM
1,212
10/27/2016 02:51PM
Re: MySQL subquery  
761
10/28/2016 01:03AM
Re: MySQL subquery  
749
11/06/2016 08:50PM
Re: MySQL subquery  
755
11/07/2016 01:39AM
7,861
10/14/2016 08:47AM
Re: Index on timestamp  
3,194
10/16/2016 04:40PM
1,227
10/12/2016 10:00AM
6,669
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
2,527
10/03/2016 03:40PM
Re: inner join vs left join - huge performance difference  
2,935
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
1,976
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
1,595
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
1,423
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
1,482
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
1,459
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
1,450
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
1,186
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
1,304
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
1,464
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
1,583
09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records  
10
09/20/2016 02:09PM
1,200
09/20/2016 09:21AM
Re: Preparse Query Rewrite Plugin DLL  
794
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
1,163
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
874
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
1,007
09/15/2016 11:34AM
Re: Preparse Query Rewrite Plugin DLL  
711
06/03/2016 03:13PM
Re: Preparse Query Rewrite Plugin DLL  
703
06/28/2016 02:12AM
Re: Preparse Query Rewrite Plugin DLL  
696
08/12/2016 05:13PM
Re: why the two query has a different execute plan?  
762
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
712
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
679
08/15/2016 09:28AM
1,374
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
973
07/08/2016 10:59AM
Re: how to optimize this sql?  
948
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
865
07/09/2016 11:04PM
Re: how to optimize this sql?  
872
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
822
07/14/2016 12:52PM
Re: Indexing for date column for range query  
743
07/09/2016 10:47PM
1,411
06/22/2016 04:44AM
Re: Help with partially unique index  
864
06/25/2016 10:45PM
Re: Help with partially unique index  
922
07/02/2016 03:33PM
Re: Help with partially unique index  
726
07/04/2016 12:50PM
Re: Explain plans for InnoDB and Memory Engines  
718
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
884
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
802
05/05/2016 10:18PM
1,227
02/02/2016 09:48PM
2,409
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
1,006
12/08/2015 08:46PM
Re: why left join can not use unique index?  
888
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
906
12/15/2015 11:08AM
This topic has been moved.:  A stored function to remove diacritics and other chars  
20
12/11/2015 03:50AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
927
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
976
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
971
12/07/2015 01:17AM
1,682
11/08/2015 11:14PM
Re: Why not use index  
841
11/09/2015 11:42AM
Re: Why not use index  
862
11/11/2015 12:17AM
Re: Why not use index  
890
11/10/2015 10:35AM
Re: Why not use index  
1,048
11/11/2015 12:15AM
Re: Why not use index  
932
11/11/2015 03:40AM
Re: Why not use index  
1,181
11/11/2015 07:29PM
Re: Why not use index  
827
11/11/2015 11:00PM
Re: Why not use index  
922
11/12/2015 01:48AM
Re: Why not use index  
888
11/16/2015 12:17AM
1,534
11/09/2015 09:35PM
Re: Google Update Optimizer system  
913
11/09/2015 10:12PM
Re: Google Update Optimizer system  
827
11/10/2015 01:02AM
2,448
10/11/2015 08:37PM
Re: Normalize dump table  
870
10/11/2015 08:42PM
Re: Normalize dump table  
1,089
10/13/2015 01:41PM
Re: Normalize dump table  
975
10/17/2015 07:15PM
Re: optimize query for index using between and group by  
1,421
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
941
08/31/2015 02:34AM
1,760
07/29/2015 10:07AM
Re: Index not working for date field used in between query  
2,038
07/26/2015 08:28AM
1,857
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
1,036
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
1,594
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
1,239
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
1,078
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
1,126
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
1,052
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
951
07/07/2015 09:10AM
Re: Need help understanding optimizer behavior in 5.6  
1,084
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
1,095
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
1,077
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
992
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
1,077
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
1,063
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
1,576
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
1,041
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
1,230
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
1,225
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
1,071
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
1,074
07/02/2015 07:48AM
This topic has been moved.:  Improve search when using IN() ORDER BY PRIMARY and LIMIT  
0
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.