MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
5,287
02/06/2006 11:08AM
Re: Subqueries too slow  
2,176
02/10/2006 09:49AM
Re: Subqueries too slow  
2,386
02/10/2006 10:43AM
Re: Subqueries too slow  
2,532
02/10/2006 03:18AM
Re: Subqueries too slow  
2,124
02/10/2006 08:51AM
Re: Subqueries too slow  
2,468
02/07/2006 08:38AM
Re: Subqueries too slow  
2,443
02/06/2006 02:17PM
Re: Subqueries too slow  
2,460
02/07/2006 07:06AM
Re: Subqueries too slow  
2,671
02/06/2006 11:54AM
2,457
02/09/2006 09:44PM
3,205
02/09/2006 09:42AM
Re: clash between unique and index keys  
2,399
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,694
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,439
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,600
02/08/2006 05:49PM
8,188
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,859
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,163
02/07/2006 12:13PM
3,096
01/17/2006 02:41PM
Re: optimize  
1,998
02/02/2006 09:02AM
Re: optimize  
2,012
01/18/2006 09:07AM
Re: optimize  
2,039
01/17/2006 06:48PM
8,172
01/12/2006 02:21PM
Re: Double Index Performance  
2,788
01/16/2006 06:24AM
Re: Double Index Performance  
2,830
01/16/2006 08:46AM
Re: Double Index Performance  
2,429
01/17/2006 06:45AM
Re: Double Index Performance  
2,704
02/01/2006 01:05PM
Re: Double Index Performance  
3,144
01/13/2006 05:18PM
Re: 'where' with 'in' doesn't use index?  
2,131
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
2,010
01/30/2006 04:45PM
2,795
01/20/2006 06:51AM
Re: subquery breaks optimization  
1,990
01/24/2006 07:14PM
2,794
01/12/2006 08:22AM
Re: mysql dont use my Index?  
1,968
01/18/2006 10:36PM
Re: does Select values effect index selection?  
1,950
01/10/2006 05:04PM
2,844
01/03/2006 02:28PM
Re: Optimizing with DATE()  
1,985
01/03/2006 06:53PM
3,245
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,185
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
2,116
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,169
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
2,055
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
2,155
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
2,115
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
2,163
11/01/2005 08:03AM
Re: select distinct slower in 5.0 than 4.1  
2,198
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,141
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,222
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,294
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,565
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,296
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,239
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,233
12/21/2005 01:54AM
4,174
11/23/2005 08:47AM
Re: Range Join Performance  
2,270
12/26/2005 07:56PM
Re: Range Join Performance  
2,212
12/21/2005 11:10PM
3,267
12/21/2005 03:19AM
Re: does my index take effect?  
2,052
12/21/2005 11:03PM
Re: Index merge optimization with joined tables?  
2,117
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,258
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,258
12/07/2005 05:37PM
8,848
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,679
12/21/2005 10:44PM
3,335
11/26/2005 04:53PM
Re: Can't get my indexes right  
2,118
12/21/2005 10:34PM
Re: Can't get my indexes right  
2,133
11/28/2005 02:19PM
Re: Can't get my indexes right  
2,008
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,252
11/28/2005 03:17AM
Re: Can't get my indexes right  
2,058
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,217
11/27/2005 07:28PM
4,605
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,217
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,692
12/16/2005 10:23AM
2,908
12/19/2005 01:46PM
4,184
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,414
12/14/2005 02:55AM
7,111
12/01/2005 08:27AM
Re: Group by Optimization  
7,679
12/14/2005 02:36AM
Re: Group by Optimization  
3,281
12/05/2005 11:29AM
Re: Group by Optimization  
3,864
12/03/2005 06:07AM
Re: Group by Optimization  
3,519
12/05/2005 11:32AM
Re: Group by Optimization  
3,369
12/09/2005 04:53PM
Re: How to force the optimizer to use an index in a sub-query?  
3,553
12/01/2005 01:51PM
Re: why don't work for my substring index?  
2,751
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,624
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,609
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,412
11/09/2005 03:07AM
3,020
11/15/2005 05:20PM
Re: WHERE clause processing  
2,091
11/15/2005 07:32PM
3,316
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,248
11/15/2005 09:20AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,392
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,449
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,483
11/08/2005 03:53AM
88,344
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,767
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,959
11/03/2005 05:18AM
4,642
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,536
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,430
11/02/2005 08:50AM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,669
11/01/2005 12:56PM
20,835
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
4,263
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
4,019
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
4,104
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
4,695
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
9,401
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
5,840
09/21/2005 08:12AM
4,892
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,651
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,484
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,563
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,577
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,515
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,533
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,749
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
3,115
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,516
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,471
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,727
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
2,880
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,629
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,635
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,592
09/07/2005 06:28PM
6,249
09/02/2005 12:39PM
Re: 2 column between optimization  
3,069
09/07/2005 02:48AM
Re: 2 column between optimization  
2,850
09/07/2005 12:25PM
Re: 2 column between optimization  
2,650
09/07/2005 12:54PM
Re: 2 column between optimization  
2,757
09/06/2005 09:14PM
Re: 2 column between optimization  
2,953
09/06/2005 09:22PM
Re: 2 column between optimization  
2,690
09/06/2005 11:17PM
Re: 2 column between optimization  
2,691
09/07/2005 02:54AM
Re: 2 column between optimization  
2,742
09/04/2005 07:21PM
Re: 2 column between optimization  
2,909
09/02/2005 02:01PM
Re: 2 column between optimization  
3,168
09/02/2005 02:25PM
Re: 2 column between optimization  
2,779
09/05/2005 12:03PM
Re: 2 column between optimization  
2,808
09/06/2005 09:18PM
Re: 2 column between optimization  
2,893
09/02/2005 03:38PM
Re: 2 column between optimization  
2,749
09/06/2005 09:17PM
Re: Unexpected benchmark results due to query optimizer?  
2,508
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,459
09/07/2005 06:47AM
Re: At Performance Limit for 2 GB RAM?  
3,217
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
3,087
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
3,051
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
2,862
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,824
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
2,839
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,788
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,671
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
3,056
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,715
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,296
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
3,272
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,756
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,712
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,675
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,386
07/22/2005 02:13PM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,432
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,739
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,771
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,352
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,617
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,370
07/18/2005 10:54AM
3,823
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,516
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
2,245
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,427
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,310
02/03/2005 08:34PM
4,657
01/03/2005 04:02AM
Re: SELECT on multiple column index  
3,163
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,448
12/10/2004 07:51AM
Re: SELECT on multiple column index  
4,439
12/10/2004 08:42AM
Re: SELECT on multiple column index  
3,128
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,551
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,620
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,428
12/09/2004 09:08AM
Re: Issues with Sub-selects and performance on Win 2003  
2,387
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,318
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,329
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,370
11/11/2004 07:11PM
2,991
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,440
10/15/2004 02:11PM
Pages:
« 1
...
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.