MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Oracle MySQL Community Early Access (EA) Builds: MySQL 9.7.0 EA now available 03/18/2026 06:38AM
Pages:
« 1
...
3 4 5 6 7
...
19 »

Subject
Views
Written By
Posted
Re: mysql subquery query optimization question  
1,494
01/13/2013 11:30AM
2,848
01/06/2013 01:00AM
Re: Create a New Datatype  
1,432
01/07/2013 11:01PM
Re: Optimizer for innodb does not reduce "data_free"  
2,035
12/08/2012 01:33PM
3,252
11/03/2012 04:16PM
Re: Complex query - need advise  
1,614
11/03/2012 04:24PM
Re: Complex query - need advise  
1,574
11/04/2012 10:05AM
Re: Complex query - need advise  
1,940
11/05/2012 11:12AM
Re: Follow up on "Query Execution Plan"  
1,556
10/25/2012 11:14AM
Re: Follow up on "Query Execution Plan"  
1,401
10/25/2012 06:15AM
2,980
10/13/2012 11:52AM
Re: JOIN query too slow  
1,460
10/14/2012 10:26AM
Re: JOIN query too slow  
1,525
10/16/2012 07:48PM
5,407
09/25/2012 02:51PM
Re: bulk update very slow  
2,183
09/26/2012 02:58PM
Re: bulk update very slow  
2,259
09/27/2012 08:19PM
Re: bulk update very slow  
3,758
09/27/2012 12:01PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,933
09/23/2012 03:46PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,850
09/23/2012 08:24PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,436
09/24/2012 11:43PM
2,797
09/17/2012 09:09AM
Re: Join? Union? I am so lost.  
1,447
09/18/2012 07:48AM
Re: How make indexes work with group by statement  
1,560
09/15/2012 10:34PM
Re: How make indexes work with group by statement  
1,569
09/13/2012 01:50AM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,460
09/06/2012 10:42PM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,552
09/06/2012 04:32AM
2,825
08/27/2012 10:47PM
Re: optimize the query  
1,461
08/28/2012 01:43AM
Re: optimize the query  
1,391
08/29/2012 04:15AM
Re: optimize the query  
1,511
08/29/2012 04:39AM
Re: optimize the query  
1,350
08/29/2012 05:38AM
Re: optimize the query  
1,447
08/30/2012 07:20AM
3,399
08/14/2012 01:06PM
Re: Query with GROUP BY not using Index  
1,735
08/15/2012 02:46AM
Re: Query with GROUP BY not using Index  
1,554
08/16/2012 10:30AM
Re: Query with GROUP BY not using Index  
1,875
08/17/2012 02:58AM
Re: Query with GROUP BY not using Index  
1,577
08/18/2012 10:30PM
Re: Query with GROUP BY not using Index  
1,539
08/24/2012 12:41PM
Re: Query with GROUP BY not using Index  
1,601
08/28/2012 03:11AM
Re: Query with GROUP BY not using Index  
1,685
08/28/2012 06:21PM
Re: Query with GROUP BY not using Index  
2,038
08/29/2012 01:28AM
Re: Query with GROUP BY not using Index  
1,489
08/29/2012 10:36AM
17,913
08/22/2012 08:45AM
Re: CONCAT and Index in where clause  
5,939
08/23/2012 01:15AM
Re: CONCAT and Index in where clause  
4,573
08/23/2012 09:13PM
Re: CONCAT and Index in where clause  
4,675
08/27/2012 09:53AM
Re: CONCAT and Index in where clause  
4,724
08/28/2012 02:50AM
Re: Simple query spending too much time in 'statistics' state without reason  
6,742
08/24/2012 06:24AM
Re: Simple query spending too much time in 'statistics' state without reason  
5,029
08/28/2012 01:53AM
Re: Simple query spending too much time in 'statistics' state without reason  
6,296
08/22/2012 07:44PM
4,003
08/22/2012 09:12AM
Re: Order By Slows down Joins  
1,332
08/23/2012 08:56PM
Re: always uses filesort even after adding indexes  
1,434
08/22/2012 10:52PM
4,316
08/19/2012 08:28PM
Re: STRAIGHT_JOIN for OUTER JOINGS  
2,241
08/20/2012 05:16AM
Re: CPU usage 99% - and query very slow - help  
2,172
08/04/2012 01:36PM
Re: CPU usage 99% - and query very slow - help  
2,965
08/06/2012 01:04PM
Re: CPU usage 99% - and query very slow - help  
2,320
08/15/2012 03:09AM
Re: Execution plan: wrong index selected, very poor performance.  
1,977
07/19/2012 10:07PM
Re: Execution plan: wrong index selected, very poor performance.  
1,793
07/20/2012 01:38AM
Re: Execution plan: wrong index selected, very poor performance.  
1,531
07/24/2012 04:27AM
Re: Execution plan: wrong index selected, very poor performance.  
1,666
07/25/2012 12:21AM
3,372
07/17/2012 12:41AM
Re: Index for Query  
1,675
07/17/2012 10:36PM
Re: Index for Query  
1,611
07/18/2012 11:52PM
Re: Index for Query  
2,299
07/19/2012 09:49PM
3,206
07/14/2012 09:54AM
Re: best way to optimize this query  
1,802
07/15/2012 10:11PM
Re: Optimizer being overly aggressive  
1,564
07/10/2012 12:49PM
Re: Optimizer being overly aggressive  
1,556
07/10/2012 08:54PM
Re: multiple-column index and order by  
1,610
07/10/2012 12:55PM
Re: performing mysqldump corrected query issue?  
1,584
07/01/2012 06:43PM
Re: performing mysqldump corrected query issue?  
1,402
06/26/2012 02:08PM
2,582
06/20/2012 04:05PM
Re: difference between READ and SCAN  
1,342
06/20/2012 08:23PM
Re: difference between READ and SCAN  
1,676
06/21/2012 12:19PM
2,546
06/14/2012 08:23AM
Re: to optimize a self join request  
1,631
06/15/2012 08:19AM
2,568
06/14/2012 10:23AM
Re: Call out for FULL JOIN - bug #18003  
1,237
06/14/2012 12:13PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,512
06/11/2012 11:27PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,451
06/12/2012 12:48AM
Re: index cannot be used when passing 'int' to 'varchar'  
1,521
06/12/2012 09:23PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,711
06/12/2012 11:16PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,463
06/13/2012 07:15PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,443
06/13/2012 10:35PM
4,215
06/02/2012 12:58AM
Re: Querying a fast subquery never returns  
1,413
05/22/2012 05:19PM
Re: Querying a fast subquery never returns  
1,738
05/24/2012 12:40AM
Re: Querying a fast subquery never returns  
1,693
05/25/2012 11:15AM
Re: Querying a fast subquery never returns  
1,558
05/26/2012 10:59AM
2,773
05/01/2012 10:55AM
Re: table index optimization  
1,347
05/02/2012 07:08PM
Re: table index optimization  
1,548
05/05/2012 09:07AM
Re: table index optimization  
1,441
05/17/2012 09:25AM
Re: table index optimization  
1,691
05/04/2012 08:20AM
3,472
05/08/2012 12:38PM
Re: Query execution plan  
1,574
05/09/2012 09:35PM
Re: Query execution plan  
1,645
05/10/2012 08:29AM
Re: Query execution plan  
1,595
05/11/2012 07:16PM
Re: Query execution plan  
1,679
05/14/2012 05:27AM
Re: Query execution plan  
1,445
05/15/2012 07:22PM
Re: Query execution plan  
1,426
05/09/2012 11:08AM
2,727
05/08/2012 10:33PM
Re: limit & scala subquery  
1,321
05/09/2012 09:21PM
2,128
04/30/2012 06:09AM
Re: 1000 Columns, 1000 Tables, or what?  
1,645
04/20/2012 06:50PM
Re: 1000 Columns, 1000 Tables, or what?  
1,443
04/23/2012 08:10AM
Re: 1000 Columns, 1000 Tables, or what?  
1,696
04/26/2012 07:59AM
2,621
04/14/2012 05:20AM
Re: Help with query/tables optimization  
1,510
04/16/2012 12:05AM
Re: Help with query/tables optimization  
1,604
04/16/2012 11:53AM
Re: Help with query/tables optimization  
1,938
04/16/2012 12:04PM
Re: Identical servers different plan for the same query  
1,614
04/10/2012 03:28PM
Re: Identical servers different plan for the same query  
1,704
04/10/2012 10:29PM
Re: Identical servers different plan for the same query  
1,534
04/11/2012 10:05AM
Re: Identical servers different plan for the same query  
1,627
04/12/2012 08:56AM
Re: Identical servers different plan for the same query  
1,623
04/12/2012 03:23PM
Re: Identical servers different plan for the same query  
2,738
04/13/2012 03:49PM
Re: Identical servers different plan for the same query  
1,592
04/07/2012 09:55AM
Re: Identical servers different plan for the same query  
1,575
04/07/2012 02:54PM
Re: Identical servers different plan for the same query  
1,881
04/08/2012 12:20PM
Re: Identical servers different plan for the same query  
2,047
04/09/2012 10:24AM
Re: Identical servers different plan for the same query  
1,652
04/09/2012 10:35AM
Re: Identical servers different plan for the same query  
1,532
04/09/2012 10:37AM
Re: Identical servers different plan for the same query  
1,636
04/09/2012 10:42AM
2,456
04/10/2012 01:58PM
3,382
04/02/2012 02:51AM
Re: LEFT JOIN WHERE GROUP BY  
1,706
04/05/2012 08:01PM
Re: LEFT JOIN WHERE GROUP BY  
1,466
04/02/2012 12:04PM
Re: LEFT JOIN WHERE GROUP BY  
1,478
04/02/2012 01:24PM
Re: LEFT JOIN WHERE GROUP BY  
1,498
04/02/2012 04:29PM
Re: LEFT JOIN WHERE GROUP BY  
2,201
04/03/2012 12:50AM
Re: LEFT JOIN WHERE GROUP BY  
1,493
04/03/2012 05:40PM
Re: LEFT JOIN WHERE GROUP BY  
1,588
04/03/2012 11:22PM
Re: LEFT JOIN WHERE GROUP BY  
1,451
04/04/2012 05:12PM
Re: LEFT JOIN WHERE GROUP BY  
1,199
04/04/2012 11:10PM
2,715
03/19/2012 01:49AM
Re: Explain the order of query  
1,410
03/19/2012 10:38PM
Re: Explain the order of query  
1,411
03/21/2012 07:06PM
Re: Explain the order of query  
1,821
03/28/2012 05:06AM
Re: Explain the order of query  
1,189
03/22/2012 06:01PM
Re: Explain the order of query  
1,180
03/22/2012 08:13PM
Re: Explain the order of query  
1,191
03/23/2012 07:57PM
This topic has been moved.:  difference between READ and SCAN  
0
06/20/2012 05:47PM
Pages:
« 1
...
3 4 5 6 7
...
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.