MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/ODBC 5.3.13 has been released 04/29/2019 05:44PM
•   MySQL Cluster 7.6.10 has been released 04/27/2019 03:25AM
•   MySQL Cluster 7.5.14 has been released 04/26/2019 12:12PM
•   MySQL Cluster 7.3.25 has been released 04/26/2019 11:34AM
•   MySQL Cluster 7.4.24 has been released 04/26/2019 11:00AM
Pages:
« 1
...
3 4 5 6 7
...
18 »

Subject
Views
Written By
Posted
1,697
02/24/2012 06:07AM
Re: Optimizing query  
887
02/25/2012 05:54PM
Re: Optimizing query  
824
02/27/2012 06:04AM
Re: Optimizing query  
900
02/28/2012 07:57PM
Re: Optimizing query  
844
02/25/2012 03:49AM
Re: Optimizing query  
1,123
02/27/2012 05:57AM
Re: Optimizing query  
952
02/24/2012 01:16PM
Re: how to optimise query for 10+ millions records  
1,418
02/09/2012 05:31AM
Re: how to optimise query for 10+ millions records  
1,082
02/09/2012 05:38AM
Re: how to optimise query for 10+ millions records  
1,001
02/09/2012 05:58PM
Re: how to optimise query for 10+ millions records  
1,000
02/11/2012 11:26PM
Re: how to optimise query for 10+ millions records  
1,174
02/12/2012 10:12PM
Re: how to optimise query for 10+ millions records  
1,074
02/13/2012 02:18PM
Re: how to optimise query for 10+ millions records  
1,257
02/14/2012 02:33AM
Re: how to optimise query for 10+ millions records  
1,014
02/14/2012 07:24AM
Re: how to optimise query for 10+ millions records  
1,076
02/15/2012 07:30AM
Re: how to optimise query for 10+ millions records  
1,478
02/16/2012 03:54AM
Re: how to optimise query for 10+ millions records  
1,013
02/17/2012 01:20AM
Re: how to optimise query for 10+ millions records  
848
02/17/2012 03:57PM
Re: how to optimise query for 10+ millions records  
1,161
02/17/2012 05:12PM
Re: how to optimise query for 10+ millions records  
952
02/20/2012 02:21AM
Re: how to optimise query for 10+ millions records  
1,053
02/18/2012 07:18AM
Re: how to optimise query for 10+ millions records  
1,036
02/21/2012 03:25AM
Re: how to optimise query for 10+ millions records  
1,074
02/24/2012 10:45AM
Join  
1,729
02/01/2012 06:51AM
Re: Join Query Performance Problme  
923
02/03/2012 10:18AM
Re: Join Query Performance Problme  
915
02/01/2012 11:14AM
Re: Join Query Performance Problme  
920
02/02/2012 12:39AM
Re: Join Query Performance Problme  
897
02/02/2012 06:47AM
Re: Join Query Performance Problme  
901
02/02/2012 07:02PM
Re: Join Query Performance Problme  
893
02/03/2012 12:29AM
Re: Join Query Performance Problme  
1,135
02/03/2012 11:27AM
Re: Join Query Performance Problme  
901
02/04/2012 10:39AM
Re: Join Query Performance Problme  
1,077
02/14/2012 06:08PM
Re: Join Query Performance Problme  
918
02/06/2012 06:13AM
3,377
02/11/2012 04:01AM
Re: query cost calculations  
1,198
02/13/2012 07:13PM
Re: query cost calculations  
1,341
02/12/2012 01:03PM
Re: Strange performance results with JOIN/COUNT  
902
02/09/2012 03:01AM
Re: Strange performance results with JOIN/COUNT  
1,251
02/09/2012 03:13AM
Re: Strange performance results with JOIN/COUNT  
1,148
02/11/2012 02:53AM
Re: Strange performance results with JOIN/COUNT  
855
02/12/2012 06:44PM
Re: Strange performance with JOIN/COUNT  
904
02/11/2012 11:11PM
Re: Why MySQL does not use an index?  
1,042
01/19/2012 12:25AM
Re: Why MySQL does not use an index?  
1,126
02/10/2012 01:21AM
Re: Why MySQL does not use an index?  
1,056
02/11/2012 10:48PM
Re: Why MySQL does not use an index?  
937
02/10/2012 09:50AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
964
02/01/2012 07:33PM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
916
02/02/2012 03:58AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
931
02/02/2012 04:43AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
896
02/03/2012 11:57PM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
1,029
02/02/2012 03:06AM
1,762
01/30/2012 03:16AM
Re: running running running  
921
01/30/2012 02:39AM
Re: running running running  
811
01/30/2012 09:13AM
Re: running running running  
745
01/31/2012 05:44AM
Re: running running running  
869
01/31/2012 07:54AM
Re: running running running  
926
01/31/2012 03:10AM
Re: running running running  
892
01/31/2012 05:00PM
3,128
01/26/2012 10:58PM
Re: How to avoid filesort in ORDER BY?  
1,428
01/27/2012 08:20AM
1,566
01/22/2012 01:08PM
Re: avoid filesort  
933
01/24/2012 01:17AM
Re: avoid filesort  
1,037
01/24/2012 04:36PM
Re: avoid filesort  
971
01/25/2012 08:26PM
Re: avoid filesort  
951
01/26/2012 04:56AM
Re: avoid filesort  
1,141
01/25/2012 07:24PM
Re: avoid filesort  
988
01/26/2012 04:57AM
Re: Simple 1-table query taking WAY to long.....  
914
01/24/2012 01:09AM
Re: want to make this query faster, but not sure how  
1,006
01/19/2012 05:39PM
Re: want to make this query faster, but not sure how  
1,175
01/20/2012 10:51AM
Re: want to make this query faster, but not sure how  
761
01/19/2012 10:12AM
Re: want to make this query faster, but not sure how  
758
01/19/2012 10:29AM
1,193
01/19/2012 12:07PM
Re: Query no longer uses index, takes much longer to run  
788
01/10/2012 01:43PM
Re: Query no longer uses index, takes much longer to run  
808
01/10/2012 03:54PM
Re: Weird issue with join buffer (Performance suffers)  
1,169
01/10/2012 01:37PM
2,462
01/04/2012 01:43PM
Re: Problem with a query performance  
1,049
01/05/2012 10:41AM
Re: Problem with a query performance  
985
01/06/2012 12:36PM
Re: Problem with a query performance  
978
01/07/2012 10:52AM
Re: index not used when join condition added  
1,029
01/03/2012 08:42PM
Re: index not used when join condition added  
1,026
01/03/2012 09:49PM
Re: index not used when join condition added  
1,265
01/04/2012 06:26PM
Re: index not used when join condition added  
948
01/04/2012 07:21PM
Re: index not used when join condition added  
898
01/04/2012 06:28PM
Re: Primary key index with a DATETIME as first part of the compound key is never used  
1,395
01/02/2012 09:06PM
2,602
10/25/2011 12:00AM
Re: help me, optimize a long running query  
996
10/26/2011 06:48AM
Re: help me, optimize a long running query  
972
10/27/2011 12:39AM
Re: help me, optimize a long running query  
1,023
10/27/2011 09:04PM
Re: help me, optimize a long running query  
1,304
12/26/2011 11:52PM
Re: help me, optimize a long running query  
849
12/27/2011 10:00PM
1,908
12/17/2011 01:24PM
Re: SELECT counter  
855
12/19/2011 06:57AM
Re: Strange behavior with a strange request  
844
12/10/2011 11:37PM
Re: Strange behavior with a strange request  
913
12/12/2011 09:01AM
3,330
11/28/2011 09:58PM
Re: left outer join performance  
1,211
11/28/2011 11:10PM
Re: left outer join performance  
1,104
11/29/2011 09:27PM
3,437
11/28/2011 11:22AM
Re: Join without duplicates  
980
11/28/2011 02:39PM
Re: Join without duplicates  
1,277
11/29/2011 04:19AM
Re: Join without duplicates  
1,475
11/29/2011 02:58PM
Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
838
11/29/2011 03:19AM
Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
763
11/28/2011 11:06AM
Re: Need to increase packet size in MySQL  
1,042
11/26/2011 08:53AM
2,070
11/19/2011 09:27AM
Re: Executing same query in 1 moment  
875
11/20/2011 04:42PM
Re: Executing same query in 1 moment  
897
11/21/2011 12:42AM
Re: Executing same query in 1 moment  
904
11/20/2011 10:31PM
Re: Executing same query in 1 moment  
806
11/22/2011 12:05AM
2,696
11/18/2011 04:18AM
Re: Slow LEFT JOIN!  
908
11/19/2011 12:42AM
1,609
11/14/2011 01:10AM
Re: table join optimize help!  
761
11/14/2011 09:24PM
Re: table join optimize help!  
874
11/16/2011 01:20AM
Re: table join optimize help!  
787
11/16/2011 09:41PM
Re: table join optimize help!  
835
11/18/2011 01:18AM
1,818
11/08/2011 01:54AM
Re: help~the statement don't use index  
1,091
11/08/2011 09:31AM
Re: help~the statement don't use index  
799
11/08/2011 09:11PM
1,714
11/06/2011 01:36AM
Re: How to optimize group by and where  
839
11/07/2011 07:06AM
Re: Optimize Query for ndb 7.2.1....  
910
10/26/2011 08:40AM
Re: Optimize Query for ndb 7.2.1....  
818
10/26/2011 06:46AM
Re: Optimize Query for ndb 7.2.1....  
755
10/26/2011 03:35AM
Re: not optimizing the table after index is created  
1,285
10/16/2011 11:02AM
Re: not optimizing the table after index is created  
937
10/18/2011 04:24AM
Re: not optimizing the table after index is created  
816
10/18/2011 09:31PM
Re: not optimizing the table after index is created  
845
10/20/2011 12:10AM
Re: not optimizing the table after index is created  
1,005
10/20/2011 09:30PM
1,395
10/18/2011 01:25AM
Re: Optimize Query  
781
10/20/2011 12:46AM
Re: optimize query -- need help  
739
10/16/2011 10:58AM
Re: optimize query -- need help  
759
10/17/2011 11:33PM
Re: optimize query -- need help  
730
10/18/2011 10:42PM
1,116
10/15/2011 01:13AM
Re: GROUP BY ,ORDER BY optimization help  
1,201
10/07/2011 11:54AM
Re: GROUP BY ,ORDER BY optimization help  
1,104
10/08/2011 03:41AM
Re: GROUP BY ,ORDER BY optimization help  
1,324
10/09/2011 08:58PM
Re: GROUP BY ,ORDER BY optimization help  
977
10/10/2011 09:22AM
Re: GROUP BY ,ORDER BY optimization help  
1,490
10/11/2011 05:36PM
Re: GROUP BY ,ORDER BY optimization help  
854
10/12/2011 10:43AM
2,210
10/05/2011 11:10PM
Re: Explain plan--join type  
942
10/07/2011 12:41AM
2,834
07/21/2011 08:57AM
Re: Mysql using 95% of cpu  
860
09/22/2011 06:11AM
Re: Mysql using 95% of cpu  
1,111
09/23/2011 09:14AM
Re: Mysql using 95% of cpu  
936
07/22/2011 07:33PM
Re: not able to use index, seems optimizer forces not to use index,  
835
09/22/2011 03:30PM
Re: not able to use index, seems optimizer forces not to use index,  
783
09/22/2011 01:24AM
Re: Query Optimisation of a slow query  
1,169
09/16/2011 10:21PM
Re: Query Optimisation of a slow query  
942
09/20/2011 01:51AM
Re: Query Optimisation of a slow query  
1,077
09/19/2011 01:01AM
Re: Query Optimisation of a slow query  
997
09/20/2011 09:20PM
Re: Query Optimisation of a slow query  
958
09/21/2011 02:38AM
Re: Query Optimisation of a slow query  
935
09/22/2011 12:03AM
Re: Query Optimisation of a slow query  
897
09/21/2011 12:21AM
2,986
07/31/2011 10:16AM
Re: Close conections  
1,422
08/08/2011 08:51AM
Re: Close conections  
933
09/17/2011 02:18PM
Re: Close conections  
947
09/18/2011 12:54PM
Re: Close conections  
996
09/18/2011 02:48PM
Re: Close conections  
929
09/19/2011 07:23PM
Re: Close conections  
874
09/20/2011 05:40AM
Re: Close conections  
1,037
09/21/2011 11:37PM
Re: combine this 2 simple querys into 1 query for performance.  
757
09/15/2011 01:50AM
Re: Strategy needed for picking random rows  
870
09/08/2011 07:51AM
Re: Strategy needed for picking random rows  
943
09/08/2011 08:05AM
Re: Strategy needed for picking random rows  
901
09/09/2011 08:51AM
Re: Strategy needed for picking random rows  
1,112
09/08/2011 01:08AM
Re: Strategy needed for picking random rows  
883
09/08/2011 01:17AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,098
09/05/2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
987
09/05/2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,059
09/06/2011 07:03PM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,096
09/01/2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
894
09/01/2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,236
09/01/2011 06:12AM
Pages:
« 1
...
3 4 5 6 7
...
18 »

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.