MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing April 2024 Releases featuring MySQL 8.4.0 and 8.0.37 04/30/2024 02:33PM

Subject
Views
Written By
Posted
5,356
02/06/2006 11:08AM
Re: Subqueries too slow  
2,212
02/10/2006 09:49AM
Re: Subqueries too slow  
2,426
02/10/2006 10:43AM
Re: Subqueries too slow  
2,573
02/10/2006 03:18AM
Re: Subqueries too slow  
2,165
02/10/2006 08:51AM
Re: Subqueries too slow  
2,501
02/07/2006 08:38AM
Re: Subqueries too slow  
2,484
02/06/2006 02:17PM
Re: Subqueries too slow  
2,502
02/07/2006 07:06AM
Re: Subqueries too slow  
2,705
02/06/2006 11:54AM
2,519
02/09/2006 09:44PM
3,271
02/09/2006 09:42AM
Re: clash between unique and index keys  
2,432
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,725
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,474
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,630
02/08/2006 05:49PM
8,261
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,905
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,205
02/07/2006 12:13PM
3,158
01/17/2006 02:41PM
Re: optimize  
2,042
02/02/2006 09:02AM
Re: optimize  
2,046
01/18/2006 09:07AM
Re: optimize  
2,082
01/17/2006 06:48PM
8,251
01/12/2006 02:21PM
Re: Double Index Performance  
2,828
01/16/2006 06:24AM
Re: Double Index Performance  
2,867
01/16/2006 08:46AM
Re: Double Index Performance  
2,475
01/17/2006 06:45AM
Re: Double Index Performance  
2,738
02/01/2006 01:05PM
Re: Double Index Performance  
3,185
01/13/2006 05:18PM
Re: 'where' with 'in' doesn't use index?  
2,174
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
2,049
01/30/2006 04:45PM
2,870
01/20/2006 06:51AM
Re: subquery breaks optimization  
2,028
01/24/2006 07:14PM
2,864
01/12/2006 08:22AM
Re: mysql dont use my Index?  
2,000
01/18/2006 10:36PM
Re: does Select values effect index selection?  
1,987
01/10/2006 05:04PM
2,907
01/03/2006 02:28PM
Re: Optimizing with DATE()  
2,018
01/03/2006 06:53PM
3,313
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,224
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
2,147
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,204
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
2,091
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
2,189
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
2,144
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
2,200
11/01/2005 08:03AM
Re: select distinct slower in 5.0 than 4.1  
2,228
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,178
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,255
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,326
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,612
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,335
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,276
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,267
12/21/2005 01:54AM
4,238
11/23/2005 08:47AM
Re: Range Join Performance  
2,316
12/26/2005 07:56PM
Re: Range Join Performance  
2,250
12/21/2005 11:10PM
3,335
12/21/2005 03:19AM
Re: does my index take effect?  
2,092
12/21/2005 11:03PM
Re: Index merge optimization with joined tables?  
2,157
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,300
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,296
12/07/2005 05:37PM
8,918
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,713
12/21/2005 10:44PM
3,395
11/26/2005 04:53PM
Re: Can't get my indexes right  
2,154
12/21/2005 10:34PM
Re: Can't get my indexes right  
2,166
11/28/2005 02:19PM
Re: Can't get my indexes right  
2,039
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,290
11/28/2005 03:17AM
Re: Can't get my indexes right  
2,091
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,249
11/27/2005 07:28PM
4,677
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,242
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,723
12/16/2005 10:23AM
2,965
12/19/2005 01:46PM
4,237
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,450
12/14/2005 02:55AM
7,188
12/01/2005 08:27AM
Re: Group by Optimization  
7,713
12/14/2005 02:36AM
Re: Group by Optimization  
3,310
12/05/2005 11:29AM
Re: Group by Optimization  
3,901
12/03/2005 06:07AM
Re: Group by Optimization  
3,541
12/05/2005 11:32AM
Re: Group by Optimization  
3,396
12/09/2005 04:53PM
Re: How to force the optimizer to use an index in a sub-query?  
3,591
12/01/2005 01:51PM
Re: why don't work for my substring index?  
2,791
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,664
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,667
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,449
11/09/2005 03:07AM
3,093
11/15/2005 05:20PM
Re: WHERE clause processing  
2,124
11/15/2005 07:32PM
3,374
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,287
11/15/2005 09:20AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,437
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,482
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,534
11/08/2005 03:53AM
88,478
11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,835
11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN  
24,999
11/03/2005 05:18AM
4,693
11/01/2005 09:59AM
Re: Optimizer - subqueries  
2,575
11/02/2005 03:52AM
Re: Optimizer - subqueries  
2,468
11/02/2005 08:50AM
Re: Does SELECT DISTINCT on an indexed column do an index scan?  
4,699
11/01/2005 12:56PM
21,086
09/20/2005 12:15PM
Re: Rows Examined, why so many?  
4,310
09/20/2005 07:10PM
Re: Rows Examined, why so many?  
4,056
09/21/2005 08:13AM
Re: Rows Examined, why so many?  
4,138
09/21/2005 05:05AM
Re: Rows Examined, why so many?  
4,743
09/20/2005 03:54PM
Re: Rows Examined, why so many?  
9,486
09/20/2005 03:18PM
Re: Rows Examined, why so many?  
5,880
09/21/2005 08:12AM
4,948
09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?  
2,678
09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?  
2,513
09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?  
2,612
09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?  
2,613
09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?  
2,560
09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?  
2,563
09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?  
2,786
09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?  
3,162
09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?  
2,556
09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?  
2,505
09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?  
2,750
09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?  
2,915
09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?  
2,671
09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?  
2,665
09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?  
2,627
09/07/2005 06:28PM
6,322
09/02/2005 12:39PM
Re: 2 column between optimization  
3,104
09/07/2005 02:48AM
Re: 2 column between optimization  
2,881
09/07/2005 12:25PM
Re: 2 column between optimization  
2,687
09/07/2005 12:54PM
Re: 2 column between optimization  
2,794
09/06/2005 09:14PM
Re: 2 column between optimization  
2,998
09/06/2005 09:22PM
Re: 2 column between optimization  
2,730
09/06/2005 11:17PM
Re: 2 column between optimization  
2,728
09/07/2005 02:54AM
Re: 2 column between optimization  
2,787
09/04/2005 07:21PM
Re: 2 column between optimization  
2,958
09/02/2005 02:01PM
Re: 2 column between optimization  
3,214
09/02/2005 02:25PM
Re: 2 column between optimization  
2,811
09/05/2005 12:03PM
Re: 2 column between optimization  
2,857
09/06/2005 09:18PM
Re: 2 column between optimization  
2,934
09/02/2005 03:38PM
Re: 2 column between optimization  
2,795
09/06/2005 09:17PM
Re: Unexpected benchmark results due to query optimizer?  
2,546
09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?  
2,487
09/07/2005 06:47AM
Re: At Performance Limit for 2 GB RAM?  
3,257
07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?  
3,119
07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?  
3,084
07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?  
2,898
07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?  
2,855
07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?  
2,870
07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?  
2,824
08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?  
2,703
08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?  
3,088
08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?  
2,747
07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?  
3,331
08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?  
3,303
08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?  
3,791
08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?  
2,744
07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?  
2,710
07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?  
3,429
07/22/2005 02:13PM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,467
07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,780
07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,809
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,381
07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,669
07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?  
2,414
07/18/2005 10:54AM
3,905
02/02/2005 10:39AM
Re: Why does this query take 2 minutes?  
2,551
02/02/2005 07:36PM
Re: Why does this query take 2 minutes?  
2,277
02/03/2005 07:21AM
Re: Why does this query take 2 minutes?  
2,465
02/03/2005 08:43PM
Re: Why does this query take 2 minutes?  
2,346
02/03/2005 08:34PM
4,705
01/03/2005 04:02AM
Re: SELECT on multiple column index  
3,205
12/09/2004 07:38PM
Re: SELECT on multiple column index  
3,494
12/10/2004 07:51AM
Re: SELECT on multiple column index  
4,474
12/10/2004 08:42AM
Re: SELECT on multiple column index  
3,155
12/10/2004 10:23AM
Re: SELECT on multiple column index  
3,580
12/10/2004 11:02AM
Re: SELECT on multiple column index  
3,659
12/09/2004 11:23AM
Re: SELECT on multiple column index  
3,460
12/09/2004 09:08AM
Re: Issues with Sub-selects and performance on Win 2003  
2,417
11/06/2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003  
2,358
11/11/2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003  
2,361
11/12/2004 05:49AM
Re: Issues with Sub-selects and performance on Win 2003  
2,404
11/11/2004 07:11PM
3,029
10/15/2004 12:35PM
Re: Query Optimizer Problems  
2,469
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.