MySQL Forums
Forum List  »  Optimizer & Parser

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

Subject
Views
Written By
Posted
Optimize subquery, replace IN() with JOIN  
1,751
Miron jajtic
11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN  
716
Peter Brawley
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
799
Miron jajtic
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
717
Rick James
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
683
Peter Brawley
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
728
Miron jajtic
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
671
Peter Brawley
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
775
Miron jajtic
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
685
Peter Brawley
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
500
sahar gull
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
599
Øystein Grøvlen
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
645
Miron jajtic
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
739
Øystein Grøvlen
11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery  
718
Edwin Desouza
12/23/2016 08:50AM
primary key vs covered index  
1,144
marcin kot
11/30/2016 09:55AM
Re: primary key vs covered index  
611
Øystein Grøvlen
12/01/2016 01:39AM
Re: primary key vs covered index  
610
marcin kot
12/01/2016 03:38AM
Re: primary key vs covered index  
647
Øystein Grøvlen
12/01/2016 03:57AM
Re: primary key vs covered index  
571
marcin kot
12/01/2016 04:16AM
Re: primary key vs covered index  
507
Øystein Grøvlen
12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser  
810
Edwin Desouza
11/22/2016 10:58AM
MySQL subquery  
1,001
harry sheng
10/27/2016 02:51PM
Re: MySQL subquery  
614
Øystein Grøvlen
10/28/2016 01:03AM
Re: MySQL subquery  
611
harry sheng
11/06/2016 08:50PM
Re: MySQL subquery  
638
Øystein Grøvlen
11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance  
823
Edwin Desouza
10/21/2016 09:58AM
Index on timestamp  
7,223
Adeline M
10/14/2016 08:47AM
Re: Index on timestamp  
2,972
Rick James
10/16/2016 04:40PM
MySQL 8.0: Descending Indexes  
1,038
Edwin Desouza
10/12/2016 10:00AM
Pivot table with dynamic columns  
6,124
Aram Mirzadeh
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
2,313
Rick James
10/03/2016 03:40PM
inner join vs left join - huge performance difference  
11,100
michael cook
07/06/2016 09:32AM
Re: inner join vs left join - huge performance difference  
2,566
Peter Brawley
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
1,662
michael cook
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
1,352
michael cook
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
1,212
Peter Brawley
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
1,288
michael cook
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
1,203
michael cook
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
1,223
Peter Brawley
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
963
michael cook
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
1,077
Rick James
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
1,252
Peter Brawley
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
1,275
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  
753
Edwin Desouza
09/20/2016 09:21AM
Preparse Query Rewrite Plugin DLL  
1,785
Francois Haddad
08/12/2016 05:16PM
Re: Preparse Query Rewrite Plugin DLL  
660
Georgi Kodinov
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
902
Francois Haddad
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
701
Tor Didriksen
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
789
Francois Haddad
09/15/2016 11:34AM
Preparse Query Rewrite Plugin DLL  
1,516
Francois Haddad
06/03/2016 12:41PM
Re: Preparse Query Rewrite Plugin DLL  
613
Francois Haddad
06/03/2016 03:13PM
Re: Preparse Query Rewrite Plugin DLL  
599
Georgi Kodinov
06/28/2016 02:12AM
Re: Preparse Query Rewrite Plugin DLL  
581
Francois Haddad
08/12/2016 05:13PM
why the two query has a different execute plan?  
1,468
h h
08/22/2016 02:55AM
Re: why the two query has a different execute plan?  
646
Øystein Grøvlen
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
590
Rick James
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
550
Francois Haddad
08/15/2016 09:28AM
how to optimize this sql?  
1,122
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
742
Peter Brawley
07/08/2016 10:59AM
Re: how to optimize this sql?  
671
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
695
Rick James
07/09/2016 11:04PM
Re: how to optimize this sql?  
686
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
709
Rick James
07/14/2016 12:52PM
Indexing for date column for range query  
1,067
duc minh
07/05/2016 11:04PM
Re: Indexing for date column for range query  
646
Rick James
07/09/2016 10:47PM
Help with partially unique index  
1,227
El T
06/22/2016 04:44AM
Re: Help with partially unique index  
718
Rick James
06/25/2016 10:45PM
Re: Help with partially unique index  
766
El T
07/02/2016 03:33PM
Re: Help with partially unique index  
612
Rick James
07/04/2016 12:50PM
Explain plans for InnoDB and Memory Engines  
1,236
Jagan Kumar
05/02/2016 03:15PM
Re: Explain plans for InnoDB and Memory Engines  
578
Peter Brawley
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
738
Øystein Grøvlen
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
694
Rick James
05/05/2016 10:18PM
MySQL Query Rewrite Plugins  
1,093
Edwin Desouza
02/02/2016 09:48PM
why left join can not use unique index?  
2,097
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
887
Rick James
12/08/2015 08:46PM
Re: why left join can not use unique index?  
771
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
798
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,301
Michael W.
11/16/2015 11:14AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
802
Rick James
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
855
Michael W.
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
816
Rick James
12/07/2015 01:17AM
Why not use index  
1,472
zhang peng
11/08/2015 11:14PM
Re: Why not use index  
717
Peter Brawley
11/09/2015 11:42AM
Re: Why not use index  
746
zhang peng
11/11/2015 12:17AM
Re: Why not use index  
785
Øystein Grøvlen
11/10/2015 10:35AM
Re: Why not use index  
928
zhang peng
11/11/2015 12:15AM
Re: Why not use index  
760
Øystein Grøvlen
11/11/2015 03:40AM
Re: Why not use index  
1,033
zhang peng
11/11/2015 07:29PM
Re: Why not use index  
727
Peter Brawley
11/11/2015 11:00PM
Re: Why not use index  
809
Øystein Grøvlen
11/12/2015 01:48AM
Re: Why not use index  
783
zhang peng
11/16/2015 12:17AM
Google Update Optimizer system  
1,327
Anik Bhowmik
11/09/2015 09:35PM
Re: Google Update Optimizer system  
747
Peter Brawley
11/09/2015 10:12PM
Re: Google Update Optimizer system  
734
Jonathan Stephens
11/10/2015 01:02AM
Normalize dump table  
2,065
Jose Valle
10/11/2015 08:37PM
Re: Normalize dump table  
733
Jose Valle
10/11/2015 08:42PM
Re: Normalize dump table  
902
Antonio Valle
10/13/2015 01:41PM
Re: Normalize dump table  
836
Rick James
10/17/2015 07:15PM
optimize query for index using between and group by  
2,224
Raghavendra raghu
08/28/2015 03:21AM
Re: optimize query for index using between and group by  
1,289
Rick James
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
811
Raghavendra raghu
08/31/2015 02:34AM
Parsing in MySQL Workbench: the ANTLR age  
1,506
Edwin Desouza
08/14/2015 10:16AM
MySQL Optimizer: Hints  
1,572
Edwin Desouza
07/29/2015 10:07AM
Index not working for date field used in between query  
5,014
Shrinivasa rao
07/22/2015 11:48PM
Re: Index not working for date field used in between query  
1,874
Rick James
07/26/2015 08:28AM
MyISAM using 'wrong' index  
1,649
Danny Stommen
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
937
Rick James
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
1,452
Danny Stommen
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
1,111
Rick James
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
922
Danny Stommen
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
968
Rick James
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
908
Danny Stommen
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
851
Edwin Desouza
07/07/2015 09:10AM
Need help understanding optimizer behavior in 5.6  
1,915
Aaron Craven
06/22/2015 08:30AM
Re: Need help understanding optimizer behavior in 5.6  
953
Aaron Craven
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
951
Rick James
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
947
Aaron Craven
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
853
Rick James
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
908
Aaron Craven
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
909
Øystein Grøvlen
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
1,353
Aaron Craven
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
917
Aaron Craven
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
1,037
Øystein Grøvlen
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
1,049
Aaron Craven
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
935
Edwin Desouza
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
926
Aaron Craven
07/02/2015 07:48AM
MySQL 5.7: Optimizer Trace and EXPLAIN FORMAT=JSON  
1,882
Edwin Desouza
05/25/2015 10:41AM
foreign key creation in a huge database  
1,825
Raffael Vendrametto
03/05/2015 04:05PM
Please do NOT duplicate posts  
942
Peter Brawley
03/05/2015 05:42PM
Query Taking 2.5hrs on 5.6.20 version  
2,240
ch srinivas
03/04/2015 01:30AM
Re: Query Taking 2.5hrs on 5.6.20 version  
1,064
Peter Brawley
03/04/2015 12:15PM
Re: Query Taking 2.5hrs on 5.6.20 version  
980
Rick James
03/04/2015 08:18PM
Query optimisation advice  
2,075
Paul Feely
01/08/2015 11:02PM
Re: Query optimisation advice  
1,075
Rick James
01/10/2015 01:22AM
Re: Query optimisation advice  
1,005
Paul Feely
01/11/2015 05:50PM
Re: Query optimisation advice  
1,065
Rick James
01/12/2015 10:35PM
actual Size calculation of mysql table (engine innodb)  
1,983
Afaque Ahmad Siddiqui
12/10/2014 09:38AM
Re: actual Size calculation of mysql table (engine innodb)  
1,093
Rick James
12/12/2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)  
1,162
Rick James
12/12/2014 08:36PM
MySQL cash optimization  
2,227
Sasha Katsman
11/27/2014 06:33AM
Re: MySQL cash optimization  
1,317
Peter Brawley
11/27/2014 04:34PM
Re: MySQL cash optimization  
1,022
Sasha Katsman
12/09/2014 04:33AM
Re: MySQL cache optimization  
910
Peter Brawley
12/09/2014 12:28PM
how to tune for optimizer_search_depth?  
2,212
jongse park
12/03/2014 12:13AM
Re: how to tune for optimizer_search_depth?  
1,441
Rick James
12/03/2014 11:33PM
Re: how to tune for optimizer_search_depth?  
1,373
Øystein Grøvlen
12/08/2014 05:32AM
MySQL Optimizer Cost Model  
1,893
Edwin Desouza
10/24/2014 10:37AM
Need help to create index on join statments  
2,034
Neil Sorathia
10/08/2014 06:24PM
Re: Need help to create index on join statments  
981
Neil Sorathia
10/09/2014 09:46AM
Re: Need help to create index on join statments  
1,085
Rick James
10/11/2014 01:37PM
Better Performance for JOINs Not Using Indexes  
1,784
Edwin Desouza
10/03/2014 01:48PM
A Multi-Table Trick to Speed up Single-Table UPDATE/DELETE Statements  
2,051
Edwin Desouza
10/03/2014 01:47PM
MySQL 5.7: Optimizer Hints + Query Rewrite  
1,984
Edwin Desouza
10/01/2014 08:53AM
Intermediate Query Results  
2,943
Ashwini Singh
09/12/2014 08:37AM
Re: Intermediate Query Results  
1,401
Rick James
09/13/2014 09:23PM
Re: Intermediate Query Results  
1,447
Øystein Grøvlen
09/15/2014 05:42AM
All records scanning using "LIKe" and "IN" operaters  
2,303
ch srinivas
06/28/2014 01:43PM
Re: All records scanning using "LIKe" and "IN" operaters  
1,140
Peter Brawley
06/28/2014 02:22PM
Re: All records scanning using "LIKe" and "IN" operaters  
1,096
Øystein Grøvlen
08/28/2014 03:47PM
Help me to optimize my sql query  
2,146
GAURAV JAIN
08/21/2014 07:29AM
Re: Help me to optimize my sql query  
1,067
Rick James
08/22/2014 06:50AM
How could this SQL be optimized?  
2,205
feng guo
05/29/2014 11:26PM
Re: How could this SQL be optimized?  
1,108
Øystein Grøvlen
05/30/2014 02:41AM
Re: How could this SQL be optimized?  
1,187
feng guo
05/30/2014 02:46AM
Re: How could this SQL be optimized?  
1,033
Marion Gordon
08/21/2014 11:03PM
Re: How could this SQL be optimized?  
1,065
Øystein Grøvlen
08/22/2014 01:54AM
simple uses of order by datetime keep causing 'using filesort'  
2,301
park albert
08/19/2014 05:44PM
Re: simple uses of order by datetime keep causing 'using filesort'  
1,225
Rick James
08/20/2014 07:34PM
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.