MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
7,795
01/12/2006 02:21PM
Re: Double Index Performance  
2,584
01/16/2006 06:24AM
Re: Double Index Performance  
2,651
01/16/2006 08:46AM
Re: Double Index Performance  
2,312
01/17/2006 06:45AM
Re: Double Index Performance  
2,494
02/01/2006 01:05PM
Re: Double Index Performance  
3,010
01/13/2006 05:18PM
Re: 'where' with 'in' doesn't use index?  
1,984
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
1,892
01/30/2006 04:45PM
2,529
01/20/2006 06:51AM
Re: subquery breaks optimization  
1,858
01/24/2006 07:14PM
2,551
01/12/2006 08:22AM
Re: mysql dont use my Index?  
1,844
01/18/2006 10:36PM
Re: does Select values effect index selection?  
1,840
01/10/2006 05:04PM
2,602
01/03/2006 02:28PM
Re: Optimizing with DATE()  
1,859
01/03/2006 06:53PM
2,899
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,019
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
1,944
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,005
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
1,899
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
1,967
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
1,904
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
1,977
11/01/2005 08:03AM
Re: select distinct slower in 5.0 than 4.1  
2,034
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,004
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,062
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,069
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,342
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,107
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,033
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,031
12/21/2005 01:54AM
3,850
11/23/2005 08:47AM
Re: Range Join Performance  
2,071
12/26/2005 07:56PM
Re: Range Join Performance  
2,064
12/21/2005 11:10PM
2,920
12/21/2005 03:19AM
Re: does my index take effect?  
1,870
12/21/2005 11:03PM
Re: Index merge optimization with joined tables?  
1,967
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,096
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,123
12/07/2005 05:37PM
8,532
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,515
12/21/2005 10:44PM
3,034
11/26/2005 04:53PM
Re: Can't get my indexes right  
1,984
12/21/2005 10:34PM
Re: Can't get my indexes right  
1,987
11/28/2005 02:19PM
Re: Can't get my indexes right  
1,869
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,110
11/28/2005 03:17AM
Re: Can't get my indexes right  
1,928
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,030
11/27/2005 07:28PM
4,234
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,072
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,455
12/16/2005 10:23AM
2,674
12/19/2005 01:46PM
3,847
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,229
12/14/2005 02:55AM
6,672
12/01/2005 08:27AM
Re: Group by Optimization  
7,267
12/14/2005 02:36AM
Re: Group by Optimization  
3,108
12/05/2005 11:29AM
Re: Group by Optimization  
3,640
12/03/2005 06:07AM
Re: Group by Optimization  
3,246
12/05/2005 11:32AM
Re: Group by Optimization  
3,133
12/09/2005 04:53PM
Re: How to force the optimizer to use an index in a sub-query?  
3,376
12/01/2005 01:51PM
Re: why don't work for my substring index?  
2,545
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,422
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,371
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,247
11/09/2005 03:07AM
2,732
11/15/2005 05:20PM
Re: WHERE clause processing  
1,933
11/15/2005 07:32PM
2,974
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,040
11/15/2005 09:20AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,078
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,209
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,127
11/08/2005 03:53AM
87,449
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,264
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,601
11/03/2005 05:18AM
4,265
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,317
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,208
11/02/2005 08:50AM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,389
11/01/2005 12:56PM
15,582
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
3,740
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
3,474
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
3,555
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
4,012
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
8,012
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
4,977
09/21/2005 08:12AM
4,454
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,418
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,289
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,322
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,341
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,300
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,292
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,497
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
2,876
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,302
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,247
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,459
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
2,646
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,402
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,408
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,361
09/07/2005 06:28PM
5,837
09/02/2005 12:39PM
Re: 2 column between optimization  
2,807
09/07/2005 02:48AM
Re: 2 column between optimization  
2,615
09/07/2005 12:25PM
Re: 2 column between optimization  
2,415
09/07/2005 12:54PM
Re: 2 column between optimization  
2,500
09/06/2005 09:14PM
Re: 2 column between optimization  
2,669
09/06/2005 09:22PM
Re: 2 column between optimization  
2,453
09/06/2005 11:17PM
Re: 2 column between optimization  
2,454
09/07/2005 02:54AM
Re: 2 column between optimization  
2,502
09/04/2005 07:21PM
Re: 2 column between optimization  
2,671
09/02/2005 02:01PM
Re: 2 column between optimization  
2,801
09/02/2005 02:25PM
Re: 2 column between optimization  
2,496
09/05/2005 12:03PM
Re: 2 column between optimization  
2,560
09/06/2005 09:18PM
Re: 2 column between optimization  
2,674
09/02/2005 03:38PM
Re: 2 column between optimization  
2,511
09/06/2005 09:17PM
Re: Unexpected benchmark results due to query optimizer?  
2,292
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,261
09/07/2005 06:47AM
Re: At Performance Limit for 2 GB RAM?  
2,944
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
2,797
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
2,793
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
2,534
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,524
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
2,571
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,491
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,425
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
2,815
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,456
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,056
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
3,011
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,394
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,444
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,456
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,070
07/22/2005 02:13PM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,246
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,471
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,498
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,183
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,354
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,213
07/18/2005 10:54AM
3,296
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,268
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
1,983
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,122
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,104
02/03/2005 08:34PM
4,260
01/03/2005 04:02AM
Re: SELECT on multiple column index  
2,934
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,137
12/10/2004 07:51AM
Re: SELECT on multiple column index  
2,956
12/10/2004 08:42AM
Re: SELECT on multiple column index  
2,863
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,278
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,296
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,256
12/09/2004 09:08AM
Re: Issues with Sub-selects and performance on Win 2003  
2,194
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,114
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,147
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,170
11/11/2004 07:11PM
2,693
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,257
10/15/2004 02:11PM
Pages:
« 1
...
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.