MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
2,946
01/25/2007 08:49AM
Re: File Sort  
2,006
01/26/2007 07:50AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,338
01/24/2007 05:52AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,242
01/24/2007 06:07AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,291
01/24/2007 06:18AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,151
01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,321
01/24/2007 07:32AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,159
01/24/2007 06:41AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,169
01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,246
01/24/2007 08:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,332
01/24/2007 08:50AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,291
01/24/2007 09:24AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,173
01/24/2007 03:19PM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,103
01/25/2007 07:27AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,415
01/24/2007 10:29AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,241
01/24/2007 10:40AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,177
01/24/2007 09:10AM
2,607
01/16/2007 03:58PM
Re: Need help optmizing query  
2,011
01/16/2007 06:42PM
Re: How to optimize a derived table required for re-ordering.  
3,051
01/15/2007 08:41AM
3,052
01/12/2007 10:28AM
Re: Help optimizing a slow query entry  
1,971
01/15/2007 08:30AM
14,270
04/29/2006 08:56AM
Re: Having problems with ORDER BY COUNT  
5,107
01/15/2007 03:35AM
Re: Having problems with ORDER BY COUNT  
4,728
01/15/2007 08:28AM
3,886
01/08/2007 05:14PM
3,719
01/04/2007 07:38AM
Re: Make this faster?  
2,323
01/04/2007 03:34PM
Re: Make this faster?  
2,299
01/05/2007 02:40AM
Re: Make this faster?  
2,221
01/05/2007 05:07AM
Re: Make this faster?  
2,232
01/05/2007 08:31AM
Re: Make this faster?  
2,276
01/05/2007 08:45AM
Re: Make this faster?  
2,253
01/08/2007 02:44AM
Re: Make this faster?  
2,194
01/08/2007 04:28AM
Re: Make this faster?  
2,236
01/08/2007 04:41AM
Re: Make this faster?  
2,355
01/05/2007 03:11PM
Re: Make this faster?  
2,217
01/05/2007 06:55AM
Re: Make this faster?  
2,251
01/05/2007 08:31AM
Re: Make this faster?  
2,270
01/05/2007 08:33AM
Re: Make this faster?  
2,432
01/05/2007 08:45AM
Re: Make this faster?  
2,259
01/04/2007 10:21AM
Re: Make this faster?  
2,217
01/04/2007 11:51AM
3,448
12/15/2006 07:54AM
Re: REGEXP is not optimized?  
2,446
01/05/2007 08:57AM
4,323
01/02/2007 09:24AM
Re: Two general MySQL questions  
2,154
01/02/2007 08:11PM
Re: Two general MySQL questions  
2,153
01/03/2007 05:35PM
Re: Two general MySQL questions  
2,159
01/03/2007 06:10PM
Re: Two general MySQL questions  
2,147
01/04/2007 05:49AM
Re: Two general MySQL questions  
2,149
01/04/2007 10:53AM
Re: i've got the query optimization blues ... stumped  
2,078
01/04/2007 10:32AM
Re: How to optimize the "order by" & "limit" query?  
2,222
01/04/2007 10:25AM
2,646
01/02/2007 05:59AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,317
12/06/2006 02:03AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,078
12/07/2006 12:19AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,202
12/25/2006 06:35AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,577
11/30/2006 08:18PM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,642
12/01/2006 12:21AM
50,131
09/05/2006 09:17PM
Re: optimization with table_cache  
19,875
12/20/2006 02:45AM
Re: optimization with table_cache  
20,397
12/18/2006 10:40PM
Re: optimization with table_cache  
20,182
12/20/2006 02:37AM
3,134
09/04/2006 03:10AM
Re: Optimizer Tool  
2,226
12/13/2006 04:57AM
Re: Optimizer Tool  
3,399
12/13/2006 07:39PM
3,109
11/02/2006 08:28AM
Re: Creating an index to include ORDER BY  
1,936
11/02/2006 05:31PM
Re: Creating an index to include ORDER BY  
2,041
11/03/2006 09:24AM
Re: Creating an index to include ORDER BY  
2,003
12/13/2006 05:02AM
Re: Bad performance caused by DISTINCT?  
3,383
12/13/2006 04:46AM
Re: Bad performance caused by DISTINCT?  
4,337
11/19/2006 09:29PM
Re: Two possible indexes in simple select but none is used  
1,902
12/13/2006 04:41AM
Re: Two possible indexes in simple select but none is used  
1,944
11/28/2006 06:27PM
3,094
11/28/2006 11:40AM
Re: how turn off optimizer?  
2,926
11/28/2006 06:25PM
Re: how turn off optimizer?  
2,698
11/30/2006 02:04AM
Re: how turn off optimizer?  
2,336
12/12/2006 06:24PM
Re: how turn off optimizer?  
2,315
11/28/2006 11:24PM
Re: Golden Rules of writting efficient query  
2,485
12/08/2006 08:28AM
Re: Golden Rules of writting efficient query  
3,284
11/23/2006 02:17AM
14,478
11/27/2006 05:50PM
A more general way to do it  
4,054
12/05/2006 08:43AM
Improvements to "constify"  
3,838
12/07/2006 06:26AM
Re: Liberating Dependent Subqueries  
3,073
12/01/2006 09:35AM
Re: Liberating Dependent Subqueries  
2,778
12/03/2006 06:21PM
Re: Liberating Dependent Subqueries  
2,823
12/03/2006 08:18PM
Re: Liberating Dependent Subqueries  
2,846
12/05/2006 06:11AM
Re: Liberating Dependent Subqueries  
3,380
11/28/2006 06:29PM
Re: Liberating Dependent Subqueries  
4,174
11/30/2006 05:39PM
Re: Liberating Dependent Subqueries  
3,824
11/28/2006 12:57AM
Re: Liberating Dependent Subqueries  
3,477
11/28/2006 03:09AM
Re: Update with dependent subquery needs optimization!  
2,160
12/07/2006 02:04AM
3,959
12/06/2006 07:56AM
Re: optimizer using sql_no_cache  
1,988
12/06/2006 11:07AM
2,808
11/28/2006 10:37AM
Re: Optimizing a query  
1,882
11/28/2006 06:28PM
42,747
11/15/2006 05:13AM
Re: Multiple join and Where clause  
6,851
11/22/2006 04:20PM
4,176
11/10/2006 01:56PM
Re: Including set type in index  
2,392
11/12/2006 06:55PM
Re: Including set type in index  
2,198
11/13/2006 09:36AM
ignore  
2,588
11/10/2006 03:44AM
Re: deleting approx. 180m records a month  
1,972
11/06/2006 07:04PM
2,803
10/31/2006 01:32PM
Re: Query cache  
2,016
10/31/2006 04:12PM
Re: Query cache  
1,963
11/01/2006 06:27AM
Re: Query cache  
1,997
11/01/2006 12:25PM
Re: Query cache  
2,081
11/02/2006 03:11AM
3,190
10/25/2006 04:31AM
Re: optimizing abs()  
2,249
10/25/2006 05:37AM
Re: optimizing abs()  
1,964
10/29/2006 07:31AM
5,264
10/27/2006 09:51AM
Re: Optimizer ignores datetime index  
3,431
10/27/2006 12:48PM
Re: Optimizer ignores datetime index  
2,803
10/27/2006 01:09PM
Re: Derived tables optimized differently than when directly queried?  
2,109
10/26/2006 05:33PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,512
10/21/2006 10:55AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,935
10/22/2006 04:56AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,329
10/21/2006 11:17AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,885
10/23/2006 06:41AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,639
10/23/2006 11:02AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,309
10/23/2006 01:01PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,695
10/21/2006 05:20PM
2,737
09/15/2006 06:28AM
Re: Optimizer ignores number of records  
1,903
10/21/2006 05:05AM
2,882
10/12/2006 06:34PM
Re: Performance of two similar Selects  
1,928
10/17/2006 02:07PM
Re: How to speed up query of indexed column with 5M rows?  
5,077
10/09/2006 07:54PM
Re: How to speed up query of indexed column with 5M rows?  
6,511
10/09/2006 09:40AM
Re: How to speed up query of indexed column with 5M rows?  
6,106
10/09/2006 08:39PM
Re: How to speed up query of indexed column with 5M rows?  
8,982
10/09/2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?  
7,511
10/10/2006 12:23AM
Re: How to speed up query of indexed column with 5M rows?  
6,533
10/12/2006 07:57PM
Re: How to speed up query of indexed column with 5M rows?  
6,835
10/10/2006 08:45AM
10,684
10/06/2006 06:37AM
Re: Deactivate an activate Database  
3,859
10/06/2006 09:35AM
Re: Deactivate an activate Database  
3,316
10/06/2006 11:12PM
Re: Deactivate an activate Database  
3,100
10/06/2006 11:48PM
Re: improving speed of mysql distance filter  
3,613
06/29/2006 07:54PM
Re: improving speed of mysql distance filter  
3,113
06/28/2006 11:27AM
Re: improving speed of mysql distance filter  
3,301
06/17/2006 03:12PM
Re: improving speed of mysql distance filter  
4,755
06/28/2006 01:40AM
Re: improving speed of mysql distance filter  
5,357
10/05/2006 09:56AM
Re: improving speed of mysql distance filter  
3,337
06/17/2006 02:52PM
2,900
10/01/2006 08:56AM
Re: strange query performance  
1,898
10/01/2006 11:56AM
Re: strange query performance  
1,909
10/03/2006 02:43AM
12,091
09/13/2006 12:32AM
Re: ORDER BY doesn't use index  
3,825
09/13/2006 02:36AM
Re: ORDER BY doesn't use index  
3,480
09/27/2006 03:39AM
Re: ORDER BY doesn't use index  
3,315
09/27/2006 05:02AM
Re: ORDER BY doesn't use index  
3,235
09/30/2006 05:53PM
Re: ORDER BY doesn't use index  
3,247
10/03/2006 02:38AM
Re: ORDER BY doesn't use index  
5,327
09/13/2006 02:00AM
Re: Optimizing left outer join query  
4,698
09/25/2006 03:00AM
Re: Optimizing left outer join query  
4,181
09/25/2006 04:54AM
Re: Optimizing left outer join query  
4,413
09/25/2006 08:09AM
Re: Optimizing left outer join query  
3,706
09/25/2006 09:55PM
Re: Optimizing left outer join query  
3,545
09/26/2006 03:35AM
Re: Optimizing left outer join query  
3,095
09/26/2006 06:31PM
Re: Optimizing left outer join query  
3,192
09/26/2006 03:46AM
Re: Optimizing left outer join query  
5,026
09/26/2006 04:06AM
Re: MySQL can't find index = really slow query...  
1,812
09/25/2006 08:49AM
Re: MySQL can't find index = really slow query...  
1,834
09/25/2006 09:06AM
Re: MySQL can't find index = really slow query...  
2,234
09/25/2006 09:23AM
Re: MySQL can't find index = really slow query...  
1,986
09/25/2006 09:47AM
Re: MySQL can't find index = really slow query...  
1,767
09/25/2006 09:55AM
Re: MySQL can't find index = really slow query...  
1,938
09/25/2006 10:14AM
Re: MySQL can't find index = really slow query...  
2,019
09/25/2006 12:47PM
Re: MySQL can't find index = really slow query...  
1,810
09/26/2006 04:31AM
4,828
09/21/2006 06:56PM
Re: does MySQL support function index?  
4,780
09/21/2006 10:14PM
3,204
09/11/2006 04:37AM
Re: index choose and analyze table  
2,504
09/14/2006 08:25AM
Re: index choose and analyze table  
10,641
09/14/2006 10:38AM
Re: index choose and analyze table  
3,251
09/19/2006 04:34AM
Pages:
« 1
...
14 15 16 17 18
...
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.