MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
5,544
02/06/2006 11:08AM
Re: Subqueries too slow  
2,314
02/10/2006 09:49AM
Re: Subqueries too slow  
2,530
02/10/2006 10:43AM
Re: Subqueries too slow  
2,687
02/10/2006 03:18AM
Re: Subqueries too slow  
2,255
02/10/2006 08:51AM
Re: Subqueries too slow  
2,594
02/07/2006 08:38AM
Re: Subqueries too slow  
2,579
02/06/2006 02:17PM
Re: Subqueries too slow  
2,594
02/07/2006 07:06AM
Re: Subqueries too slow  
2,803
02/06/2006 11:54AM
2,668
02/09/2006 09:44PM
3,410
02/09/2006 09:42AM
Re: clash between unique and index keys  
2,515
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,798
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,567
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,726
02/08/2006 05:49PM
8,439
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,995
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,286
02/07/2006 12:13PM
3,322
01/17/2006 02:41PM
Re: optimize  
2,133
02/02/2006 09:02AM
Re: optimize  
2,142
01/18/2006 09:07AM
Re: optimize  
2,180
01/17/2006 06:48PM
8,453
01/12/2006 02:21PM
Re: Double Index Performance  
2,929
01/16/2006 06:24AM
Re: Double Index Performance  
2,990
01/16/2006 08:46AM
Re: Double Index Performance  
2,560
01/17/2006 06:45AM
Re: Double Index Performance  
2,831
02/01/2006 01:05PM
Re: Double Index Performance  
3,299
01/13/2006 05:18PM
Re: 'where' with 'in' doesn't use index?  
2,258
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
2,144
01/30/2006 04:45PM
3,037
01/20/2006 06:51AM
Re: subquery breaks optimization  
2,102
01/24/2006 07:14PM
3,022
01/12/2006 08:22AM
Re: mysql dont use my Index?  
2,083
01/18/2006 10:36PM
Re: does Select values effect index selection?  
2,080
01/10/2006 05:04PM
3,084
01/03/2006 02:28PM
Re: Optimizing with DATE()  
2,109
01/03/2006 06:53PM
3,599
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,317
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
2,245
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,324
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
2,188
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
2,284
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
2,225
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
2,305
11/01/2005 08:03AM
Re: select distinct slower in 5.0 than 4.1  
2,319
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,291
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,347
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,423
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,718
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,449
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,381
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,367
12/21/2005 01:54AM
4,438
11/23/2005 08:47AM
Re: Range Join Performance  
2,418
12/26/2005 07:56PM
Re: Range Join Performance  
2,346
12/21/2005 11:10PM
3,509
12/21/2005 03:19AM
Re: does my index take effect?  
2,184
12/21/2005 11:03PM
Re: Index merge optimization with joined tables?  
2,245
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,416
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,410
12/07/2005 05:37PM
9,129
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,801
12/21/2005 10:44PM
3,568
11/26/2005 04:53PM
Re: Can't get my indexes right  
2,254
12/21/2005 10:34PM
Re: Can't get my indexes right  
2,255
11/28/2005 02:19PM
Re: Can't get my indexes right  
2,120
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,394
11/28/2005 03:17AM
Re: Can't get my indexes right  
2,184
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,348
11/27/2005 07:28PM
4,938
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,345
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,822
12/16/2005 10:23AM
3,125
12/19/2005 01:46PM
4,419
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,526
12/14/2005 02:55AM
7,382
12/01/2005 08:27AM
Re: Group by Optimization  
7,831
12/14/2005 02:36AM
Re: Group by Optimization  
3,420
12/05/2005 11:29AM
Re: Group by Optimization  
3,986
12/03/2005 06:07AM
Re: Group by Optimization  
3,634
12/05/2005 11:32AM
Re: Group by Optimization  
3,495
12/09/2005 04:53PM
Re: How to force the optimizer to use an index in a sub-query?  
3,685
12/01/2005 01:51PM
Re: why don't work for my substring index?  
2,914
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,781
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,819
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,547
11/09/2005 03:07AM
3,278
11/15/2005 05:20PM
Re: WHERE clause processing  
2,228
11/15/2005 07:32PM
3,553
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,381
11/15/2005 09:20AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,566
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,590
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,686
11/08/2005 03:53AM
88,760
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
25,004
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
25,121
11/03/2005 05:18AM
4,871
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,680
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,564
11/02/2005 08:50AM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,794
11/01/2005 12:56PM
21,669
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
4,438
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
4,182
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
4,266
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
4,867
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
9,698
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
6,035
09/21/2005 08:12AM
5,166
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,828
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,615
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,723
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,722
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,667
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,673
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,924
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
3,322
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,705
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,627
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,851
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
3,026
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,799
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,779
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,751
09/07/2005 06:28PM
6,547
09/02/2005 12:39PM
Re: 2 column between optimization  
3,197
09/07/2005 02:48AM
Re: 2 column between optimization  
2,998
09/07/2005 12:25PM
Re: 2 column between optimization  
2,802
09/07/2005 12:54PM
Re: 2 column between optimization  
2,879
09/06/2005 09:14PM
Re: 2 column between optimization  
3,125
09/06/2005 09:22PM
Re: 2 column between optimization  
2,920
09/06/2005 11:17PM
Re: 2 column between optimization  
2,828
09/07/2005 02:54AM
Re: 2 column between optimization  
2,883
09/04/2005 07:21PM
Re: 2 column between optimization  
3,065
09/02/2005 02:01PM
Re: 2 column between optimization  
3,343
09/02/2005 02:25PM
Re: 2 column between optimization  
2,899
09/05/2005 12:03PM
Re: 2 column between optimization  
2,973
09/06/2005 09:18PM
Re: 2 column between optimization  
3,041
09/02/2005 03:38PM
Re: 2 column between optimization  
2,888
09/06/2005 09:17PM
Re: Unexpected benchmark results due to query optimizer?  
2,661
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,600
09/07/2005 06:47AM
Re: At Performance Limit for 2 GB RAM?  
3,445
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
3,290
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
3,207
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
3,023
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,960
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
3,006
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,938
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,814
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
3,206
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,865
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,468
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
3,414
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,913
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,856
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,825
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,606
07/22/2005 02:13PM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,583
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,875
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,929
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,478
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,783
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,515
07/18/2005 10:54AM
4,104
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,638
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
2,384
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,554
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,459
02/03/2005 08:34PM
4,878
01/03/2005 04:02AM
10,173
12/05/2004 07:18AM
Re: SELECT on multiple column index  
3,318
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,632
12/10/2004 07:51AM
Re: SELECT on multiple column index  
4,589
12/10/2004 08:42AM
Re: SELECT on multiple column index  
3,266
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,703
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,801
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,581
12/09/2004 09:08AM
Re: Issues with Sub-selects and performance on Win 2003  
2,517
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,452
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,469
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,501
11/11/2004 07:11PM
3,217
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,566
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.