Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.17 has been released 11/21/2014 03:21PM
MySQL Workbench 6.2.4 GA has been released 11/20/2014 07:19AM
MySQL Connector/NET 6.9.5 has been released 11/12/2014 03:37PM
MySQL Connector/NET 6.8.4 has been released 11/11/2014 05:14PM
MySQL Connector/NET 6.7.6 has been released 11/11/2014 04:34PM
Current Page: 12 of 16
Subject Views Written By Posted
Optimising query with self-join and GROUP BY   6,549 Richard Fairhurst 05/07/2007 01:24PM
Re: Optimising query with self-join and GROUP BY   2,824 Björn Steinbrink 05/09/2007 05:21PM
Re: Optimising query with self-join and GROUP BY   2,177 Richard Fairhurst 05/13/2007 03:12PM
select + order by + limit 0,1   6,039 Markus Doppelbauer 05/11/2007 01:10AM
Re: select + order by + limit 0,1   2,294 Markus Doppelbauer 05/11/2007 01:22AM
How to optimize I/O?   2,278 gpslocator 05/09/2007 09:41PM
Huge amount of data   3,351 Sebastien Salou 04/25/2007 02:47AM
Re: Huge amount of data   1,811 KimSeong Loh 04/29/2007 10:23PM
Re: Huge amount of data   1,778 justin jose 05/02/2007 10:37PM
Need to optimise complex query   2,284 Ben Sebborn 04/29/2007 04:13PM
Re: Need to optimise complex query   1,712 KimSeong Loh 04/29/2007 10:21PM
Re: Need to optimise complex query   1,672 Ben Sebborn 04/30/2007 05:00AM
Re: Need to optimise complex query   1,720 KimSeong Loh 04/30/2007 08:36PM
Random-row queries   4,294 James Yopp 04/29/2007 06:35PM
how to create the index for three fields?   2,518 justin ux 04/24/2007 08:35PM
Query performance on indexed columns   2,014 marco rossi 04/24/2007 06:52AM
Table JOIN causes FULLSCAN despite of indeces   2,175 Denis 04/19/2007 11:58AM
CPU 99%   2,187 Neela Mahendran 04/17/2007 09:47PM
Optimizing index use in select statement   5,072 Andrey Kondakov 04/15/2007 07:23AM
Re: Optimizing index use in select statement   2,053 KimSeong Loh 04/15/2007 03:10PM
How to Control MySQL CPU Usage   1,974 TAT LIM CHIN 04/13/2007 11:39AM
Index on difference of two columns   2,853 Marty - 04/08/2007 09:31AM
Re: Index on difference of two columns   1,733 KimSeong Loh 04/11/2007 06:38AM
Re: Index on difference of two columns   1,717 Marty - 04/12/2007 12:06AM
otimize search with wildcar "%" ?   2,397 edson fernando 04/07/2007 12:02AM
Re: otimize search with wildcar "%" ?   1,621 KimSeong Loh 04/08/2007 09:01AM
help - join query optimization   2,121 Brian Kohan 04/05/2007 09:18AM
how to analyze this query_cache status   2,562 d h 03/30/2007 12:46AM
Slow Queries   1,991 Farrukh Ahmed 03/29/2007 02:32AM
Slow Subquery - Optimization in this simple query needed   3,633 elissaios 03/27/2007 11:42PM
Re: Slow Subquery - Optimization in this simple query needed   1,986 Björn Steinbrink 03/28/2007 06:22PM
Re: Slow Subquery - Optimization in this simple query needed   2,203 KimSeong Loh 03/28/2007 05:59PM
Optimize Multiple CPUs on Windows 2003 Server   2,660 Thomas Mockbee 03/28/2007 02:01PM
Limiting query research to a specified n. of records   2,252 marco rossi 03/16/2007 04:35AM
Re: Limiting query research to a specified n. of records   1,665 Björn Steinbrink 03/16/2007 09:59AM
B-Tree index ignored. Why?   5,649 Daniel Terry 03/14/2007 12:46PM
Re: B-Tree index ignored. Why?   2,362 KimSeong Loh 03/14/2007 07:39PM
Optimizing a Query   2,032 Drew Kutcharian 03/12/2007 08:45PM
Removing default NULL from table definition   2,673 Andrey Kondakov 03/11/2007 09:52AM
sql_no_cache added by the optimizer   2,736 alan langridge 03/08/2007 12:32PM
Re: sql_no_cache added by the optimizer   1,673 KimSeong Loh 03/08/2007 07:19PM
Extremely slow subqueries when used in joins   2,119 kalinda 03/08/2007 06:50AM
Optimizing Queries   2,097 Scott Pringle 03/06/2007 03:32PM
the query not optimized   2,071 Luca 03/02/2007 05:47AM
Optimizing this query slows it down   2,153 wm 02/28/2007 08:33AM
Re: Optimizing this query slows it down   1,561 KimSeong Loh 02/28/2007 06:26PM
low query   3,644 hakim benmouhoub 02/16/2007 03:49AM
Re: low query   1,591 Toa Sty 02/16/2007 04:44AM
Re: low query   1,527 ben hakim 02/16/2007 08:28AM
Re: low query   1,547 KimSeong Loh 02/25/2007 11:55PM
MySQL Optimizer Blogs by Sergey Petrunia   2,353 Edwin DeSouza 02/24/2007 12:54AM
how to explain this table status   2,163 rei 02/06/2007 04:33AM
Re: how to explain this table status   1,617 rei 02/22/2007 08:23PM
Large database   2,546 Omar Khan 01/12/2007 07:45AM
Re: Large database   1,739 Albert Arul prakash Rajendran 02/09/2007 01:42AM
Re: Large database   1,530 Omar Khan 02/14/2007 06:55AM
Re: Large database   1,783 KimSeong Loh 02/14/2007 06:47PM
Re: Large database   1,694 Omar Khan 02/15/2007 05:35AM
Re: Large database   1,789 Sean Allin 02/15/2007 05:13PM
Indexing for queries including count   1,915 Omar Khan 02/14/2007 07:05AM
Retrieved columns affects index usage   2,024 Angus 02/13/2007 12:06PM
Re: Retrieved columns affects index usage   1,559 KimSeong Loh 02/13/2007 06:37PM
force index on text & integer joiin   3,401 Simon Cranmer 02/12/2007 11:31AM
Re: force index on text & integer joiin   1,726 KimSeong Loh 02/12/2007 07:35PM
Re: force index on text & integer joiin   1,839 Simon Cranmer 02/13/2007 07:54AM
Optimizing query with joins   2,447 kayne 06/03/2006 12:18PM
Re: Optimizing query with joins   1,645 Rob Blick 06/07/2006 10:17AM
Re: Optimizing query with joins   1,609 Rhonda Heath 02/12/2007 12:07PM
Large IN() Comparison Optimize Help   2,000 Garrett Gyssler 02/11/2007 02:51AM
How should I index the tables in this query?   2,147 Dan Bress 02/09/2007 01:35PM
Substring ignores index   5,982 Matt Ryan 09/29/2006 08:59AM
Re: Substring ignores index   3,158 Toa Sty 09/29/2006 09:48AM
Re: Substring ignores index   2,522 Denver Vender 02/09/2007 04:01AM
Help required in optimizing query   2,131 Albert Arul prakash Rajendran 02/08/2007 09:43PM
intense query with "union"   1,902 asif baloch 02/07/2007 04:54PM
my boss says mysql is not upto standard: Please reply urgent   2,005 jatin shah 02/06/2007 06:05AM
Re: my boss says mysql is not upto standard: Please reply urgent   1,593 Toa Sty 02/06/2007 09:31AM
Simple queries take a lot some times   1,961 Paolo Ragone 01/30/2007 01:04PM
ORDER BY + LIMIT   4,048 Markus Doppelbauer 11/12/2006 04:45AM
Re: ORDER BY + LIMIT   2,859 Toa Sty 11/12/2006 08:27AM
Re: ORDER BY + LIMIT   2,583 Markus Doppelbauer 11/12/2006 12:09PM
Re: ORDER BY + LIMIT   28,352 Toa Sty 11/13/2006 04:40AM
Re: ORDER BY + LIMIT   3,253 Markus Doppelbauer 01/30/2007 12:06PM
bug?? partial index gives wrong results with IN subquery   2,102 Paul Davies 01/29/2007 08:44AM
File Sort   2,143 aftab khan 01/25/2007 08:49AM
Re: File Sort   1,644 KimSeong Loh 01/26/2007 07:50AM
SQL Newbie needs urgently help! [optimizing query]   2,723 Toxic Head 01/24/2007 05:31AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,754 Toxic Head 01/24/2007 05:52AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,672 Toa Sty 01/24/2007 06:07AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,731 Toxic Head 01/24/2007 06:18AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,648 Toa Sty 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,823 Toxic Head 01/24/2007 07:32AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,673 Toxic Head 01/24/2007 06:41AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,645 Toxic Head 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,684 Toa Sty 01/24/2007 08:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,742 Toxic Head 01/24/2007 08:50AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,624 Toxic Head 01/24/2007 09:24AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,683 Björn Steinbrink 01/24/2007 03:19PM
Re: SQL Newbie needs urgently help! [optimizing query]   1,631 Toxic Head 01/25/2007 07:27AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,696 Toa Sty 01/24/2007 10:29AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,676 Toxic Head 01/24/2007 10:40AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,695 Toa Sty 01/24/2007 09:10AM
need solution for ORDER BY and COUNT   2,346 Konstantin S. 01/25/2007 05:46AM
Need help optmizing query   1,938 Pascual Angulo 01/16/2007 03:58PM
Re: Need help optmizing query   1,647 KimSeong Loh 01/16/2007 06:42PM
How to optimize a derived table required for re-ordering.   2,844 Vikash Bucha 11/25/2006 05:58AM
Re: How to optimize a derived table required for re-ordering.   2,392 Toa Sty 01/15/2007 08:41AM
Current Page: 12 of 16

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.