MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/NET 6.10.9 has been released 07/29/2019 10:27PM
•   MySQL Connector/J 5.1.48 GA has been released 07/29/2019 01:52PM
•   MySQL Cluster 7.3.26 has been released 07/23/2019 08:40AM
•   MySQL Cluster 7.4.25 has been released 07/23/2019 01:56AM
•   MySQL Cluster 7.5.15 has been released 07/23/2019 01:40AM

Subject
Views
Written By
Posted
4,446
11/12/2006 04:45AM
Re: ORDER BY + LIMIT  
3,147
11/12/2006 08:27AM
Re: ORDER BY + LIMIT  
2,928
11/12/2006 12:09PM
Re: ORDER BY + LIMIT  
30,161
11/13/2006 04:40AM
Re: ORDER BY + LIMIT  
3,489
01/30/2007 12:06PM
2,670
01/25/2007 08:49AM
Re: File Sort  
1,873
01/26/2007 07:50AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,169
01/24/2007 05:52AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,077
01/24/2007 06:07AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,134
01/24/2007 06:18AM
Re: SQL Newbie needs urgently help! [optimizing query]  
1,990
01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,174
01/24/2007 07:32AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,009
01/24/2007 06:41AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,004
01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,084
01/24/2007 08:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,172
01/24/2007 08:50AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,095
01/24/2007 09:24AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,035
01/24/2007 03:19PM
Re: SQL Newbie needs urgently help! [optimizing query]  
1,954
01/25/2007 07:27AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,203
01/24/2007 10:29AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,092
01/24/2007 10:40AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,047
01/24/2007 09:10AM
2,400
01/16/2007 03:58PM
Re: Need help optmizing query  
1,913
01/16/2007 06:42PM
Re: How to optimize a derived table required for re-ordering.  
2,866
01/15/2007 08:41AM
2,776
01/12/2007 10:28AM
Re: Help optimizing a slow query entry  
1,838
01/15/2007 08:30AM
13,920
04/29/2006 08:56AM
Re: Having problems with ORDER BY COUNT  
4,981
01/15/2007 03:35AM
Re: Having problems with ORDER BY COUNT  
4,531
01/15/2007 08:28AM
3,614
01/08/2007 05:14PM
3,394
01/04/2007 07:38AM
Re: Make this faster?  
2,171
01/04/2007 03:34PM
Re: Make this faster?  
2,123
01/05/2007 02:40AM
Re: Make this faster?  
2,072
01/05/2007 05:07AM
Re: Make this faster?  
2,066
01/05/2007 08:31AM
Re: Make this faster?  
2,098
01/05/2007 08:45AM
Re: Make this faster?  
2,099
01/08/2007 02:44AM
Re: Make this faster?  
2,053
01/08/2007 04:28AM
Re: Make this faster?  
2,082
01/08/2007 04:41AM
Re: Make this faster?  
2,195
01/05/2007 03:11PM
Re: Make this faster?  
2,073
01/05/2007 06:55AM
Re: Make this faster?  
2,101
01/05/2007 08:31AM
Re: Make this faster?  
2,124
01/05/2007 08:33AM
Re: Make this faster?  
2,228
01/05/2007 08:45AM
Re: Make this faster?  
2,109
01/04/2007 10:21AM
Re: Make this faster?  
2,069
01/04/2007 11:51AM
3,133
12/15/2006 07:54AM
Re: REGEXP is not optimized?  
2,318
01/05/2007 08:57AM
4,091
01/02/2007 09:24AM
Re: Two general MySQL questions  
2,046
01/02/2007 08:11PM
Re: Two general MySQL questions  
2,002
01/03/2007 05:35PM
Re: Two general MySQL questions  
2,035
01/03/2007 06:10PM
Re: Two general MySQL questions  
2,010
01/04/2007 05:49AM
Re: Two general MySQL questions  
2,014
01/04/2007 10:53AM
Re: i've got the query optimization blues ... stumped  
1,951
01/04/2007 10:32AM
Re: How to optimize the "order by" & "limit" query?  
2,090
01/04/2007 10:25AM
2,445
01/02/2007 05:59AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,145
12/06/2006 02:03AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
2,959
12/07/2006 12:19AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,027
12/25/2006 06:35AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,461
11/30/2006 08:18PM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,438
12/01/2006 12:21AM
49,781
09/05/2006 09:17PM
Re: optimization with table_cache  
19,694
12/20/2006 02:45AM
Re: optimization with table_cache  
20,255
12/18/2006 10:40PM
Re: optimization with table_cache  
20,065
12/20/2006 02:37AM
2,945
09/04/2006 03:10AM
Re: Optimizer Tool  
2,106
12/13/2006 04:57AM
Re: Optimizer Tool  
3,221
12/13/2006 07:39PM
2,896
11/02/2006 08:28AM
Re: Creating an index to include ORDER BY  
1,829
11/02/2006 05:31PM
Re: Creating an index to include ORDER BY  
1,925
11/03/2006 09:24AM
Re: Creating an index to include ORDER BY  
1,876
12/13/2006 05:02AM
Re: Bad performance caused by DISTINCT?  
3,245
12/13/2006 04:46AM
Re: Bad performance caused by DISTINCT?  
4,197
11/19/2006 09:29PM
Re: Two possible indexes in simple select but none is used  
1,802
12/13/2006 04:41AM
Re: Two possible indexes in simple select but none is used  
1,833
11/28/2006 06:27PM
2,870
11/28/2006 11:40AM
Re: how turn off optimizer?  
2,633
11/28/2006 06:25PM
Re: how turn off optimizer?  
2,521
11/30/2006 02:04AM
Re: how turn off optimizer?  
2,128
12/12/2006 06:24PM
Re: how turn off optimizer?  
2,148
11/28/2006 11:24PM
Re: Golden Rules of writting efficient query  
2,325
12/08/2006 08:28AM
Re: Golden Rules of writting efficient query  
3,048
11/23/2006 02:17AM
13,708
11/27/2006 05:50PM
A more general way to do it  
3,802
12/05/2006 08:43AM
Improvements to "constify"  
3,603
12/07/2006 06:26AM
Re: Liberating Dependent Subqueries  
2,914
12/01/2006 09:35AM
Re: Liberating Dependent Subqueries  
2,613
12/03/2006 06:21PM
Re: Liberating Dependent Subqueries  
2,651
12/03/2006 08:18PM
Re: Liberating Dependent Subqueries  
2,686
12/05/2006 06:11AM
Re: Liberating Dependent Subqueries  
3,238
11/28/2006 06:29PM
Re: Liberating Dependent Subqueries  
4,003
11/30/2006 05:39PM
Re: Liberating Dependent Subqueries  
3,634
11/28/2006 12:57AM
Re: Liberating Dependent Subqueries  
3,301
11/28/2006 03:09AM
Re: Update with dependent subquery needs optimization!  
2,031
12/07/2006 02:04AM
3,735
12/06/2006 07:56AM
Re: optimizer using sql_no_cache  
1,883
12/06/2006 11:07AM
2,608
11/28/2006 10:37AM
Re: Optimizing a query  
1,777
11/28/2006 06:28PM
41,670
11/15/2006 05:13AM
Re: Multiple join and Where clause  
6,614
11/22/2006 04:20PM
3,893
11/10/2006 01:56PM
Re: Including set type in index  
2,286
11/12/2006 06:55PM
Re: Including set type in index  
2,098
11/13/2006 09:36AM
ignore  
2,402
11/10/2006 03:44AM
Re: deleting approx. 180m records a month  
1,852
11/06/2006 07:04PM
2,585
10/31/2006 01:32PM
Re: Query cache  
1,888
10/31/2006 04:12PM
Re: Query cache  
1,858
11/01/2006 06:27AM
Re: Query cache  
1,883
11/01/2006 12:25PM
Re: Query cache  
1,941
11/02/2006 03:11AM
2,975
10/25/2006 04:31AM
Re: optimizing abs()  
2,121
10/25/2006 05:37AM
Re: optimizing abs()  
1,865
10/29/2006 07:31AM
4,960
10/27/2006 09:51AM
Re: Optimizer ignores datetime index  
3,303
10/27/2006 12:48PM
Re: Optimizer ignores datetime index  
2,673
10/27/2006 01:09PM
Re: Derived tables optimized differently than when directly queried?  
1,982
10/26/2006 05:33PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,355
10/21/2006 10:55AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,738
10/22/2006 04:56AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,158
10/21/2006 11:17AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,686
10/23/2006 06:41AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,472
10/23/2006 11:02AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,134
10/23/2006 01:01PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,483
10/21/2006 05:20PM
2,543
09/15/2006 06:28AM
Re: Optimizer ignores number of records  
1,796
10/21/2006 05:05AM
2,660
10/12/2006 06:34PM
Re: Performance of two similar Selects  
1,796
10/17/2006 02:07PM
Re: How to speed up query of indexed column with 5M rows?  
4,887
10/09/2006 07:54PM
Re: How to speed up query of indexed column with 5M rows?  
6,293
10/09/2006 09:40AM
Re: How to speed up query of indexed column with 5M rows?  
5,897
10/09/2006 08:39PM
Re: How to speed up query of indexed column with 5M rows?  
8,775
10/09/2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?  
7,302
10/10/2006 12:23AM
Re: How to speed up query of indexed column with 5M rows?  
6,384
10/12/2006 07:57PM
Re: How to speed up query of indexed column with 5M rows?  
6,652
10/10/2006 08:45AM
9,338
10/06/2006 06:37AM
Re: Deactivate an activate Database  
3,426
10/06/2006 09:35AM
Re: Deactivate an activate Database  
2,959
10/06/2006 11:12PM
Re: Deactivate an activate Database  
2,797
10/06/2006 11:48PM
Re: improving speed of mysql distance filter  
3,438
06/29/2006 07:54PM
Re: improving speed of mysql distance filter  
2,990
06/28/2006 11:27AM
Re: improving speed of mysql distance filter  
3,170
06/17/2006 03:12PM
Re: improving speed of mysql distance filter  
4,480
06/28/2006 01:40AM
Re: improving speed of mysql distance filter  
5,154
10/05/2006 09:56AM
Re: improving speed of mysql distance filter  
3,215
06/17/2006 02:52PM
2,696
10/01/2006 08:56AM
Re: strange query performance  
1,777
10/01/2006 11:56AM
Re: strange query performance  
1,797
10/03/2006 02:43AM
11,716
09/13/2006 12:32AM
Re: ORDER BY doesn't use index  
3,690
09/13/2006 02:36AM
Re: ORDER BY doesn't use index  
3,335
09/27/2006 03:39AM
Re: ORDER BY doesn't use index  
3,181
09/27/2006 05:02AM
Re: ORDER BY doesn't use index  
3,090
09/30/2006 05:53PM
Re: ORDER BY doesn't use index  
3,073
10/03/2006 02:38AM
Re: ORDER BY doesn't use index  
5,179
09/13/2006 02:00AM
Re: Optimizing left outer join query  
4,539
09/25/2006 03:00AM
Re: Optimizing left outer join query  
4,017
09/25/2006 04:54AM
Re: Optimizing left outer join query  
4,200
09/25/2006 08:09AM
Re: Optimizing left outer join query  
3,542
09/25/2006 09:55PM
Re: Optimizing left outer join query  
3,373
09/26/2006 03:35AM
Re: Optimizing left outer join query  
2,933
09/26/2006 06:31PM
Re: Optimizing left outer join query  
3,041
09/26/2006 03:46AM
Re: Optimizing left outer join query  
4,761
09/26/2006 04:06AM
Re: MySQL can't find index = really slow query...  
1,699
09/25/2006 08:49AM
Re: MySQL can't find index = really slow query...  
1,723
09/25/2006 09:06AM
Re: MySQL can't find index = really slow query...  
2,076
09/25/2006 09:23AM
Re: MySQL can't find index = really slow query...  
1,860
09/25/2006 09:47AM
Re: MySQL can't find index = really slow query...  
1,648
09/25/2006 09:55AM
Re: MySQL can't find index = really slow query...  
1,780
09/25/2006 10:14AM
Re: MySQL can't find index = really slow query...  
1,884
09/25/2006 12:47PM
Re: MySQL can't find index = really slow query...  
1,662
09/26/2006 04:31AM
Pages:
« 1
...
13 14 15 16 17
...
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.