MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL for Excel 1.3.8 has been released 06/10/2019 10:21PM
Pages:
« 1
...
5 6 7 8 9
...
18 »

Subject
Views
Written By
Posted
7,461
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
3,636
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
2,597
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,194
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,216
02/08/2011 11:03AM
5,560
01/26/2011 02:07PM
Re: Max Number of Indexes?  
1,840
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,430
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,212
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,324
02/08/2011 10:41AM
Re: Help with a very slow select query  
1,202
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,018
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,058
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,017
02/02/2011 06:17AM
3,309
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,061
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,146
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,110
01/20/2011 12:17PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,197
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,065
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
1,782
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,144
11/02/2010 02:21PM
2,577
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,069
01/15/2011 12:42AM
5,272
12/27/2010 10:31PM
Re: identifying unused databases  
2,022
01/12/2011 10:31PM
Re: identifying unused databases  
1,630
01/15/2011 12:08AM
Re: identifying unused databases  
2,242
12/31/2010 08:26PM
Re: Explain shows different results on two servers  
1,484
01/14/2011 08:50AM
Re: same query sometimes very slow (punbb forum)  
1,710
01/07/2011 11:03PM
2,730
12/30/2010 10:59AM
Re: optimize select query  
1,119
12/31/2010 08:22PM
Re: optimize select query  
1,149
01/04/2011 04:07AM
Re: optimize select query  
1,381
01/06/2011 09:37PM
Re: optimize select query  
1,302
01/03/2011 01:02PM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,242
01/01/2011 07:21PM
3,733
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,698
12/26/2010 11:15AM
1,806
12/10/2010 04:02AM
Re: How to Optimize these sql?  
839
12/11/2010 02:17PM
2,308
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,088
12/05/2010 12:56PM
2,563
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,284
12/05/2010 12:45PM
Re: Optimized Indexing for a Schedule Table  
1,068
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,639
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,119
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,567
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,164
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,282
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,188
11/27/2010 02:44PM
Re: slow query sorting on group maximum  
1,249
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,120
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,397
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
1,743
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,131
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,051
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,197
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,125
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,200
11/07/2010 01:05PM
3,292
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,073
11/20/2010 11:23AM
1,784
11/18/2010 10:18PM
Re: many databases or many tables  
1,093
11/20/2010 09:28AM
Re: 'not in' query is very slow how to change it?  
3,301
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,054
11/18/2010 10:19PM
2,644
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,080
11/18/2010 01:22AM
2,207
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,281
11/18/2010 12:46AM
1,832
11/14/2010 09:40AM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,274
11/03/2010 09:17PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,242
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,865
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,254
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,567
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,228
10/30/2010 03:29PM
2,135
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
962
10/28/2010 09:44PM
2,029
10/23/2010 03:27AM
Re: Slow query  
958
10/26/2010 10:42PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,296
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,723
10/06/2010 09:11PM
Re: Database error : too many connectons  
1,422
09/14/2010 07:58AM
3,616
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,165
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,395
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,235
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,169
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,195
09/13/2010 10:56AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
939
09/09/2010 11:49PM
19,665
08/18/2010 05:46AM
Re: left join with sum and group by  
7,587
08/20/2010 11:40PM
Re: left join with sum and group by  
4,074
08/23/2010 04:26AM
Re: left join with sum and group by  
5,995
08/27/2010 08:01PM
Re: left join with sum and group by  
3,564
09/07/2010 05:08AM
3,247
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,324
08/29/2010 09:25PM
2,349
08/25/2010 03:33AM
Re: Speed problem  
1,131
08/27/2010 08:03AM
Re: SQL CACHE Not used. When it should be?  
1,804
08/17/2010 08:34AM
Re: Optimize: most recent N items with join  
1,219
08/08/2010 10:35AM
Re: Query Optimization on time-based data  
2,083
08/05/2010 10:35PM
Re: Advice on indexing a datetime column  
9,388
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
7,177
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
6,330
07/27/2010 10:29PM
Re: Estimating Index Size on Innodb Tables  
3,953
07/27/2010 08:08PM
6,287
07/22/2010 11:20AM
Re: Optimize my my.ini  
1,987
07/25/2010 10:26PM
2,424
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,151
07/21/2010 01:06PM
4,275
07/13/2010 03:30PM
Re: Analyze question  
1,373
07/14/2010 10:48PM
Re: Analyze question  
1,575
07/15/2010 11:26AM
Re: Analyze question  
1,373
07/15/2010 08:54PM
Re: query executes slowly in a table with 2m records  
1,312
07/14/2010 11:12PM
3,404
07/14/2010 10:50AM
Re: Can we write one query instead of following three query?  
1,149
07/11/2010 11:47PM
Re: multicolumn index & forcing index to avoid filesort  
1,577
07/05/2010 11:58PM
2,643
07/01/2010 05:33AM
Re: sub query  
1,382
07/02/2010 09:01PM
Re: sub query  
1,305
07/02/2010 10:39PM
2,830
06/29/2010 03:39AM
Re: Query needs to be optimized  
1,340
06/30/2010 08:50AM
Re: Query needs to be optimized  
1,658
07/01/2010 12:28AM
Re: Query needs to be optimized  
1,277
07/01/2010 09:43PM
3,976
06/16/2010 07:36AM
Re: Question on bad execution plan  
1,671
06/17/2010 09:29AM
Re: Question on bad execution plan  
1,408
06/21/2010 09:24AM
Re: Question on bad execution plan  
1,576
06/21/2010 06:47PM
Re: Question on bad execution plan  
1,639
06/22/2010 07:33AM
Re: Question on bad execution plan  
1,642
06/22/2010 09:09AM
Re: Question on bad execution plan  
1,526
06/23/2010 07:44AM
Re: Question on bad execution plan  
1,593
06/24/2010 12:17AM
Re: Question on bad execution plan  
1,649
06/24/2010 09:17PM
Re: Question on bad execution plan  
1,499
06/28/2010 02:39AM
Re: Question on bad execution plan  
1,616
06/28/2010 08:50PM
This topic has been moved.:  Analyze question  
0
07/14/2010 10:18PM
This topic has been moved.:  Query needs to be optimized  
15
06/29/2010 10:15PM
Pages:
« 1
...
5 6 7 8 9
...
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.