MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing October 2025 Releases featuring MySQL Server 9.5.0 Innovation, 8.4.7 LTS and 8.0.44 10/25/2025 05:45AM
Pages:
« 1
...
6 7 8 9 10
...
19 »

Subject
Views
Written By
Posted
3,369
02/10/2011 05:14AM
Re: select query optimize  
1,550
02/12/2011 06:56PM
Re: select query optimize  
1,485
02/14/2011 06:26AM
8,737
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
4,113
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
3,106
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,692
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,755
02/08/2011 11:03AM
6,726
01/26/2011 02:07PM
Re: Max Number of Indexes?  
2,249
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,909
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,679
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,716
02/08/2011 10:41AM
Re: Help with a very slow select query  
1,494
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,336
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,389
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,315
02/02/2011 06:17AM
3,891
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,356
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,415
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,375
01/20/2011 12:17PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,661
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,574
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,236
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,715
11/02/2010 02:21PM
3,100
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,327
01/15/2011 12:42AM
6,278
12/27/2010 10:31PM
Re: identifying unused databases  
2,409
01/12/2011 10:31PM
Re: identifying unused databases  
1,953
01/15/2011 12:08AM
Re: identifying unused databases  
2,706
12/31/2010 08:26PM
Re: Explain shows different results on two servers  
1,825
01/14/2011 08:50AM
Re: same query sometimes very slow (punbb forum)  
2,055
01/07/2011 11:03PM
3,429
12/30/2010 10:59AM
Re: optimize select query  
1,464
12/31/2010 08:22PM
Re: optimize select query  
1,583
01/04/2011 04:07AM
Re: optimize select query  
1,814
01/06/2011 09:37PM
Re: optimize select query  
1,664
01/03/2011 01:02PM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,546
01/01/2011 07:21PM
4,266
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,978
12/26/2010 11:15AM
2,324
12/10/2010 04:02AM
Re: How to Optimize these sql?  
1,140
12/11/2010 02:17PM
2,820
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,406
12/05/2010 12:56PM
3,384
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,587
12/05/2010 12:45PM
Re: Optimized Indexing for a Schedule Table  
1,359
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,994
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,431
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,864
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,489
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,589
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,480
11/27/2010 02:44PM
Re: slow query sorting on group maximum  
1,552
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,435
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,664
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
2,048
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,428
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,342
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,487
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,442
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,501
11/07/2010 01:05PM
3,802
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,339
11/20/2010 11:23AM
2,232
11/18/2010 10:18PM
Re: many databases or many tables  
1,340
11/20/2010 09:28AM
Re: 'not in' query is very slow how to change it?  
3,712
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,341
11/18/2010 10:19PM
3,208
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,344
11/18/2010 01:22AM
2,780
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,598
11/18/2010 12:46AM
2,418
11/14/2010 09:40AM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,586
11/03/2010 09:17PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,542
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
3,253
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,635
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,926
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,515
10/30/2010 03:29PM
2,632
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
1,218
10/28/2010 09:44PM
2,588
10/23/2010 03:27AM
Re: Slow query  
1,209
10/26/2010 10:42PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,584
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
2,137
10/06/2010 09:11PM
Re: Database error : too many connectons  
1,712
09/14/2010 07:58AM
4,239
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,505
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,728
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,576
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,485
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,551
09/13/2010 10:56AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
1,197
09/09/2010 11:49PM
24,588
08/18/2010 05:46AM
Re: left join with sum and group by  
8,582
08/20/2010 11:40PM
Re: left join with sum and group by  
4,694
08/23/2010 04:26AM
Re: left join with sum and group by  
6,803
08/27/2010 08:01PM
Re: left join with sum and group by  
4,210
09/07/2010 05:08AM
4,215
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,621
08/29/2010 09:25PM
2,843
08/25/2010 03:33AM
Re: Speed problem  
1,334
08/27/2010 08:03AM
Re: SQL CACHE Not used. When it should be?  
2,069
08/17/2010 08:34AM
Re: Optimize: most recent N items with join  
1,484
08/08/2010 10:35AM
Re: Query Optimization on time-based data  
2,428
08/05/2010 10:35PM
Re: Advice on indexing a datetime column  
11,670
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
8,734
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
7,749
07/27/2010 10:29PM
Re: Estimating Index Size on Innodb Tables  
4,320
07/27/2010 08:08PM
10,627
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,881
07/25/2010 10:26PM
3,086
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,408
07/21/2010 01:06PM
5,058
07/13/2010 03:30PM
Re: Analyze question  
1,711
07/14/2010 10:48PM
Re: Analyze question  
1,839
07/15/2010 11:26AM
Re: Analyze question  
1,658
07/15/2010 08:54PM
Re: query executes slowly in a table with 2m records  
1,588
07/14/2010 11:12PM
3,929
07/14/2010 10:50AM
Re: Can we write one query instead of following three query?  
1,402
07/11/2010 11:47PM
Re: multicolumn index & forcing index to avoid filesort  
1,893
07/05/2010 11:58PM
3,140
07/01/2010 05:33AM
Re: sub query  
1,623
07/02/2010 09:01PM
Re: sub query  
1,517
07/02/2010 10:39PM
3,393
06/29/2010 03:39AM
Re: Query needs to be optimized  
1,610
06/30/2010 08:50AM
Re: Query needs to be optimized  
1,927
07/01/2010 12:28AM
Re: Query needs to be optimized  
1,543
07/01/2010 09:43PM
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
...
6 7 8 9 10
...
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.