MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
5,636
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
2,065
10/03/2016 03:40PM
Re: inner join vs left join - huge performance difference  
2,351
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
1,488
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
1,212
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
1,111
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
1,189
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
1,098
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
1,109
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
877
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
988
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
1,137
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
1,192
09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records  
10
09/20/2016 02:09PM
698
09/20/2016 09:21AM
Re: Preparse Query Rewrite Plugin DLL  
606
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
805
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
643
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
723
09/15/2016 11:34AM
Re: Preparse Query Rewrite Plugin DLL  
592
06/03/2016 03:13PM
Re: Preparse Query Rewrite Plugin DLL  
561
06/28/2016 02:12AM
Re: Preparse Query Rewrite Plugin DLL  
552
08/12/2016 05:13PM
Re: why the two query has a different execute plan?  
591
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
536
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
490
08/15/2016 09:28AM
1,029
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
672
07/08/2016 10:59AM
Re: how to optimize this sql?  
618
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
633
07/09/2016 11:04PM
Re: how to optimize this sql?  
634
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
657
07/14/2016 12:52PM
Re: Indexing for date column for range query  
603
07/09/2016 10:47PM
1,159
06/22/2016 04:44AM
Re: Help with partially unique index  
645
06/25/2016 10:45PM
Re: Help with partially unique index  
701
07/02/2016 03:33PM
Re: Help with partially unique index  
570
07/04/2016 12:50PM
Re: Explain plans for InnoDB and Memory Engines  
544
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
685
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
635
05/05/2016 10:18PM
1,048
02/02/2016 09:48PM
1,990
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
829
12/08/2015 08:46PM
Re: why left join can not use unique index?  
705
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
747
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  
752
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
817
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
757
12/07/2015 01:17AM
1,394
11/08/2015 11:14PM
Re: Why not use index  
681
11/09/2015 11:42AM
Re: Why not use index  
697
11/11/2015 12:17AM
Re: Why not use index  
729
11/10/2015 10:35AM
Re: Why not use index  
872
11/11/2015 12:15AM
Re: Why not use index  
708
11/11/2015 03:40AM
Re: Why not use index  
973
11/11/2015 07:29PM
Re: Why not use index  
687
11/11/2015 11:00PM
Re: Why not use index  
754
11/12/2015 01:48AM
Re: Why not use index  
735
11/16/2015 12:17AM
1,261
11/09/2015 09:35PM
Re: Google Update Optimizer system  
696
11/09/2015 10:12PM
Re: Google Update Optimizer system  
696
11/10/2015 01:02AM
1,926
10/11/2015 08:37PM
Re: Normalize dump table  
687
10/11/2015 08:42PM
Re: Normalize dump table  
830
10/13/2015 01:41PM
Re: Normalize dump table  
771
10/17/2015 07:15PM
Re: optimize query for index using between and group by  
1,219
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
762
08/31/2015 02:34AM
1,521
07/29/2015 10:07AM
Re: Index not working for date field used in between query  
1,743
07/26/2015 08:28AM
1,574
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
877
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
1,397
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
1,034
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
861
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
918
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
861
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
812
07/07/2015 09:10AM
Re: Need help understanding optimizer behavior in 5.6  
899
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
897
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
892
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
806
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
821
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
853
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
1,295
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
862
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
983
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
991
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
892
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
876
07/02/2015 07:48AM
Please do NOT duplicate posts  
890
03/05/2015 05:42PM
Re: Query Taking 2.5hrs on 5.6.20 version  
1,011
03/04/2015 12:15PM
Re: Query Taking 2.5hrs on 5.6.20 version  
929
03/04/2015 08:18PM
2,006
01/08/2015 11:02PM
Re: Query optimisation advice  
1,036
01/10/2015 01:22AM
Re: Query optimisation advice  
970
01/11/2015 05:50PM
Re: Query optimisation advice  
1,019
01/12/2015 10:35PM
Re: actual Size calculation of mysql table (engine innodb)  
1,021
12/12/2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)  
1,109
12/12/2014 08:36PM
2,148
11/27/2014 06:33AM
Re: MySQL cash optimization  
1,256
11/27/2014 04:34PM
Re: MySQL cash optimization  
950
12/09/2014 04:33AM
Re: MySQL cache optimization  
870
12/09/2014 12:28PM
Re: how to tune for optimizer_search_depth?  
1,389
12/03/2014 11:33PM
Re: how to tune for optimizer_search_depth?  
1,326
12/08/2014 05:32AM
1,834
10/24/2014 10:37AM
Re: Need help to create index on join statments  
942
10/09/2014 09:46AM
Re: Need help to create index on join statments  
1,054
10/11/2014 01:37PM
2,830
09/12/2014 08:37AM
Re: Intermediate Query Results  
1,354
09/13/2014 09:23PM
Re: Intermediate Query Results  
1,401
09/15/2014 05:42AM
Re: All records scanning using "LIKe" and "IN" operaters  
1,106
06/28/2014 02:22PM
Re: All records scanning using "LIKe" and "IN" operaters  
1,061
08/28/2014 03:47PM
2,093
08/21/2014 07:29AM
Re: Help me to optimize my sql query  
1,041
08/22/2014 06:50AM
2,149
05/29/2014 11:26PM
Re: How could this SQL be optimized?  
1,070
05/30/2014 02:41AM
Re: How could this SQL be optimized?  
1,150
05/30/2014 02:46AM
Re: How could this SQL be optimized?  
1,003
08/21/2014 11:03PM
Re: How could this SQL be optimized?  
1,031
08/22/2014 01:54AM
Re: simple uses of order by datetime keep causing 'using filesort'  
1,184
08/20/2014 07:34PM
Re: Expland and slow-query don't agree  
939
08/04/2014 01:23PM
2,327
06/13/2014 07:51AM
Re: Query not using index sporadically  
1,049
06/18/2014 02:48PM
2,129
05/28/2014 08:56PM
1,978
04/16/2014 02:07PM
Re: BETWEEN a DATE and a hard place  
1,032
04/18/2014 05:19PM
Re: BETWEEN a DATE and a hard place  
1,111
04/21/2014 08:36AM
Re: BETWEEN a DATE and a hard place  
1,071
04/24/2014 08:20PM
Re: BETWEEN a DATE and a hard place  
1,221
04/25/2014 06:36AM
Re: BETWEEN a DATE and a hard place  
1,019
04/26/2014 05:46AM
Re: BETWEEN a DATE and a hard place  
1,057
04/28/2014 07:27AM
Re: BETWEEN a DATE and a hard place  
1,114
05/01/2014 09:41AM
Re: BETWEEN a DATE and a hard place  
1,160
05/02/2014 11:39AM
Re: Access mysql blob data from stored procedure  
1,173
04/15/2014 11:14AM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,408
03/06/2014 11:21PM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,315
03/06/2014 11:23PM
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.