MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
2,970
02/07/2006 04:21PM
Re: SUBQUERY PROBLEM  
1,893
02/13/2006 12:16PM
Re: SUBQUERY PROBLEM  
2,042
02/13/2006 11:17AM
Re: SUBQUERY PROBLEM  
1,943
02/13/2006 11:22AM
Re: SUBQUERY PROBLEM  
2,096
02/13/2006 11:06AM
Re: SUBQUERY PROBLEM  
1,945
02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team  
1,949
02/08/2006 10:26AM
Re: SUBQUERY PROBLEM  
2,000
02/08/2006 04:57AM
Re: SUBQUERY PROBLEM  
1,881
02/08/2006 03:59PM
Re: SUBQUERY PROBLEM  
1,994
02/07/2006 04:45PM
Re: SUBQUERY PROBLEM  
1,901
02/07/2006 04:52PM
4,993
02/06/2006 11:08AM
Re: Subqueries too slow  
2,072
02/10/2006 09:49AM
Re: Subqueries too slow  
2,207
02/10/2006 10:43AM
Re: Subqueries too slow  
2,318
02/10/2006 03:18AM
Re: Subqueries too slow  
2,004
02/10/2006 08:51AM
Re: Subqueries too slow  
2,306
02/07/2006 08:38AM
Re: Subqueries too slow  
2,316
02/06/2006 02:17PM
Re: Subqueries too slow  
2,283
02/07/2006 07:06AM
Re: Subqueries too slow  
2,516
02/06/2006 11:54AM
2,218
02/09/2006 09:44PM
2,995
02/09/2006 09:42AM
Re: clash between unique and index keys  
2,288
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,520
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,317
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,457
02/08/2006 05:49PM
7,911
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,664
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,026
02/07/2006 12:13PM
2,814
01/17/2006 02:41PM
Re: optimize  
1,868
02/02/2006 09:02AM
Re: optimize  
1,901
01/18/2006 09:07AM
Re: optimize  
1,888
01/17/2006 06:48PM
7,831
01/12/2006 02:21PM
Re: Double Index Performance  
2,615
01/16/2006 06:24AM
Re: Double Index Performance  
2,676
01/16/2006 08:46AM
Re: Double Index Performance  
2,334
01/17/2006 06:45AM
Re: Double Index Performance  
2,524
02/01/2006 01:05PM
Re: Double Index Performance  
3,025
01/13/2006 05:18PM
Re: 'where' with 'in' doesn't use index?  
2,016
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
1,912
01/30/2006 04:45PM
2,557
01/20/2006 06:51AM
Re: subquery breaks optimization  
1,873
01/24/2006 07:14PM
2,584
01/12/2006 08:22AM
Re: mysql dont use my Index?  
1,859
01/18/2006 10:36PM
Re: does Select values effect index selection?  
1,856
01/10/2006 05:04PM
2,635
01/03/2006 02:28PM
Re: Optimizing with DATE()  
1,876
01/03/2006 06:53PM
2,932
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,042
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
1,960
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,026
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
1,918
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
2,000
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
1,936
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
2,005
11/01/2005 08:03AM
Re: select distinct slower in 5.0 than 4.1  
2,053
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,027
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,080
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,099
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,374
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,137
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,062
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,064
12/21/2005 01:54AM
3,894
11/23/2005 08:47AM
Re: Range Join Performance  
2,097
12/26/2005 07:56PM
Re: Range Join Performance  
2,089
12/21/2005 11:10PM
2,968
12/21/2005 03:19AM
Re: does my index take effect?  
1,886
12/21/2005 11:03PM
Re: Index merge optimization with joined tables?  
1,983
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,122
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,138
12/07/2005 05:37PM
8,574
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,532
12/21/2005 10:44PM
3,071
11/26/2005 04:53PM
Re: Can't get my indexes right  
2,001
12/21/2005 10:34PM
Re: Can't get my indexes right  
2,001
11/28/2005 02:19PM
Re: Can't get my indexes right  
1,885
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,133
11/28/2005 03:17AM
Re: Can't get my indexes right  
1,943
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,055
11/27/2005 07:28PM
4,278
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,096
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,490
12/16/2005 10:23AM
2,700
12/19/2005 01:46PM
3,883
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,251
12/14/2005 02:55AM
6,725
12/01/2005 08:27AM
Re: Group by Optimization  
7,319
12/14/2005 02:36AM
Re: Group by Optimization  
3,127
12/05/2005 11:29AM
Re: Group by Optimization  
3,672
12/03/2005 06:07AM
Re: Group by Optimization  
3,286
12/05/2005 11:32AM
Re: Group by Optimization  
3,162
12/09/2005 04:53PM
Re: How to force the optimizer to use an index in a sub-query?  
3,407
12/01/2005 01:51PM
Re: why don't work for my substring index?  
2,572
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,450
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,413
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,266
11/09/2005 03:07AM
2,760
11/15/2005 05:20PM
Re: WHERE clause processing  
1,949
11/15/2005 07:32PM
3,027
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,067
11/15/2005 09:20AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,119
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,238
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,168
11/08/2005 03:53AM
87,519
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,323
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,635
11/03/2005 05:18AM
4,315
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,346
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,239
11/02/2005 08:50AM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,418
11/01/2005 12:56PM
15,935
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
3,793
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
3,529
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
3,612
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
4,085
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
8,137
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
5,055
09/21/2005 08:12AM
4,506
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,445
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,307
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,349
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,374
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,328
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,326
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,531
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
2,903
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,328
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,279
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,494
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
2,673
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,435
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,433
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,396
09/07/2005 06:28PM
5,891
09/02/2005 12:39PM
Re: 2 column between optimization  
2,848
09/07/2005 02:48AM
Re: 2 column between optimization  
2,652
09/07/2005 12:25PM
Re: 2 column between optimization  
2,443
09/07/2005 12:54PM
Re: 2 column between optimization  
2,535
09/06/2005 09:14PM
Re: 2 column between optimization  
2,700
09/06/2005 09:22PM
Re: 2 column between optimization  
2,482
09/06/2005 11:17PM
Re: 2 column between optimization  
2,486
09/07/2005 02:54AM
Re: 2 column between optimization  
2,539
09/04/2005 07:21PM
Re: 2 column between optimization  
2,700
09/02/2005 02:01PM
Re: 2 column between optimization  
2,847
09/02/2005 02:25PM
Re: 2 column between optimization  
2,526
09/05/2005 12:03PM
Re: 2 column between optimization  
2,595
09/06/2005 09:18PM
Re: 2 column between optimization  
2,703
09/02/2005 03:38PM
Re: 2 column between optimization  
2,542
09/06/2005 09:17PM
Re: Unexpected benchmark results due to query optimizer?  
2,322
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,291
09/07/2005 06:47AM
Re: At Performance Limit for 2 GB RAM?  
2,984
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
2,838
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
2,833
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
2,580
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,564
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
2,608
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,530
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,460
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
2,849
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,492
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,086
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
3,048
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,437
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,474
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,485
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,114
07/22/2005 02:13PM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,262
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,511
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,528
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,207
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,382
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,235
07/18/2005 10:54AM
3,342
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,296
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
2,008
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,161
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,121
02/03/2005 08:34PM
4,314
01/03/2005 04:02AM
Re: SELECT on multiple column index  
2,967
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,174
12/10/2004 07:51AM
Re: SELECT on multiple column index  
4,231
12/10/2004 08:42AM
Re: SELECT on multiple column index  
2,907
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,316
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,335
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,283
12/09/2004 09:08AM
Re: Issues with Sub-selects and performance on Win 2003  
2,229
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,137
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,165
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,198
11/11/2004 07:11PM
2,733
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,285
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.