Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/Python 2.1.2 Beta has been released 04/30/2015 07:02PM
MySQL Enterprise Monitor 3.0.21 has been released 04/29/2015 12:16PM
MySQL Workbench 6.3.3 GA has been released 04/24/2015 08:36AM
MySQL Connector/Python 2.0.4 GA has been released 04/22/2015 02:03AM
MySQL Cluster 7.3.9 has been released 04/15/2015 11:11PM
Current Page: 12 of 16
Subject Views Written By Posted
Index optimizations for huge table   2,601 Mennan Kara 04/30/2007 08:57PM
Re: Index optimizations for huge table   1,925 Sergey Petrunya 05/22/2007 03:38PM
Index fields order   2,709 Andrey Kondakov 05/14/2007 08:35AM
Re: Index fields order   1,834 Sergey Petrunya 05/22/2007 03:19PM
Re: Index fields order   1,848 Andrey Kondakov 05/14/2007 09:14AM
Functions in the where clause   3,628 John Dzilvelis 05/21/2007 10:26AM
Re: Functions in the where clause   2,181 Timour Katchaounov 05/22/2007 04:50AM
datetime vs date,time   7,794 Alberto González 05/16/2007 02:31AM
Re: datetime vs date,time   2,705 KimSeong Loh 05/17/2007 06:08AM
Re: datetime vs date,time   2,589 Alberto González 05/17/2007 10:08AM
Re: datetime vs date,time   3,192 Jonathan Webb 05/17/2007 05:07AM
Use of join buffer is now visible in EXPLAIN   2,307 Edwin DeSouza 05/15/2007 10:21PM
Index distribution stats   1,917 Gabriel Tataranu 05/12/2007 09:54PM
Re: Index distribution stats   1,782 Gabriel Tataranu 05/13/2007 05:42PM
Optimising query with self-join and GROUP BY   6,731 Richard Fairhurst 05/07/2007 01:24PM
Re: Optimising query with self-join and GROUP BY   2,880 Björn Steinbrink 05/09/2007 05:21PM
Re: Optimising query with self-join and GROUP BY   2,205 Richard Fairhurst 05/13/2007 03:12PM
select + order by + limit 0,1   6,103 Markus Doppelbauer 05/11/2007 01:10AM
Re: select + order by + limit 0,1   2,328 Markus Doppelbauer 05/11/2007 01:22AM
How to optimize I/O?   2,336 gpslocator 05/09/2007 09:41PM
Huge amount of data   3,426 Sebastien Salou 04/25/2007 02:47AM
Re: Huge amount of data   1,840 KimSeong Loh 04/29/2007 10:23PM
Re: Huge amount of data   1,815 justin jose 05/02/2007 10:37PM
Need to optimise complex query   2,356 Ben Sebborn 04/29/2007 04:13PM
Re: Need to optimise complex query   1,735 KimSeong Loh 04/29/2007 10:21PM
Re: Need to optimise complex query   1,702 Ben Sebborn 04/30/2007 05:00AM
Re: Need to optimise complex query   1,763 KimSeong Loh 04/30/2007 08:36PM
Random-row queries   4,446 James Yopp 04/29/2007 06:35PM
how to create the index for three fields?   2,597 justin ux 04/24/2007 08:35PM
Query performance on indexed columns   2,086 marco rossi 04/24/2007 06:52AM
Table JOIN causes FULLSCAN despite of indeces   2,243 Denis 04/19/2007 11:58AM
CPU 99%   2,221 Neela Mahendran 04/17/2007 09:47PM
Optimizing index use in select statement   5,198 Andrey Kondakov 04/15/2007 07:23AM
Re: Optimizing index use in select statement   2,078 KimSeong Loh 04/15/2007 03:10PM
How to Control MySQL CPU Usage   2,034 TAT LIM CHIN 04/13/2007 11:39AM
Index on difference of two columns   2,910 Marty - 04/08/2007 09:31AM
Re: Index on difference of two columns   1,759 KimSeong Loh 04/11/2007 06:38AM
Re: Index on difference of two columns   1,748 Marty - 04/12/2007 12:06AM
otimize search with wildcar "%" ?   2,449 edson fernando 04/07/2007 12:02AM
Re: otimize search with wildcar "%" ?   1,642 KimSeong Loh 04/08/2007 09:01AM
help - join query optimization   2,213 Brian Kohan 04/05/2007 09:18AM
how to analyze this query_cache status   2,640 d h 03/30/2007 12:46AM
Slow Queries   2,059 Farrukh Ahmed 03/29/2007 02:32AM
Slow Subquery - Optimization in this simple query needed   3,709 elissaios 03/27/2007 11:42PM
Re: Slow Subquery - Optimization in this simple query needed   2,023 Björn Steinbrink 03/28/2007 06:22PM
Re: Slow Subquery - Optimization in this simple query needed   2,228 KimSeong Loh 03/28/2007 05:59PM
Optimize Multiple CPUs on Windows 2003 Server   2,713 Thomas Mockbee 03/28/2007 02:01PM
Limiting query research to a specified n. of records   2,328 marco rossi 03/16/2007 04:35AM
Re: Limiting query research to a specified n. of records   1,698 Björn Steinbrink 03/16/2007 09:59AM
B-Tree index ignored. Why?   5,781 Daniel Terry 03/14/2007 12:46PM
Re: B-Tree index ignored. Why?   2,380 KimSeong Loh 03/14/2007 07:39PM
Optimizing a Query   2,098 Drew Kutcharian 03/12/2007 08:45PM
Removing default NULL from table definition   2,746 Andrey Kondakov 03/11/2007 09:52AM
sql_no_cache added by the optimizer   2,815 alan langridge 03/08/2007 12:32PM
Re: sql_no_cache added by the optimizer   1,699 KimSeong Loh 03/08/2007 07:19PM
Extremely slow subqueries when used in joins   2,184 kalinda 03/08/2007 06:50AM
Optimizing Queries   2,139 Scott Pringle 03/06/2007 03:32PM
the query not optimized   2,123 Luca 03/02/2007 05:47AM
Optimizing this query slows it down   2,238 wm 02/28/2007 08:33AM
Re: Optimizing this query slows it down   1,588 KimSeong Loh 02/28/2007 06:26PM
low query   3,731 hakim benmouhoub 02/16/2007 03:49AM
Re: low query   1,622 Toa Sty 02/16/2007 04:44AM
Re: low query   1,563 ben hakim 02/16/2007 08:28AM
Re: low query   1,573 KimSeong Loh 02/25/2007 11:55PM
MySQL Optimizer Blogs by Sergey Petrunia   2,407 Edwin DeSouza 02/24/2007 12:54AM
how to explain this table status   2,231 rei 02/06/2007 04:33AM
Re: how to explain this table status   1,648 rei 02/22/2007 08:23PM
Large database   2,619 Omar Khan 01/12/2007 07:45AM
Re: Large database   1,802 Albert Arul prakash Rajendran 02/09/2007 01:42AM
Re: Large database   1,574 Omar Khan 02/14/2007 06:55AM
Re: Large database   1,819 KimSeong Loh 02/14/2007 06:47PM
Re: Large database   1,726 Omar Khan 02/15/2007 05:35AM
Re: Large database   1,830 Sean Allin 02/15/2007 05:13PM
Indexing for queries including count   1,987 Omar Khan 02/14/2007 07:05AM
Retrieved columns affects index usage   2,093 Angus 02/13/2007 12:06PM
Re: Retrieved columns affects index usage   1,588 KimSeong Loh 02/13/2007 06:37PM
force index on text & integer joiin   3,461 Simon Cranmer 02/12/2007 11:31AM
Re: force index on text & integer joiin   1,760 KimSeong Loh 02/12/2007 07:35PM
Re: force index on text & integer joiin   1,867 Simon Cranmer 02/13/2007 07:54AM
Optimizing query with joins   2,513 kayne 06/03/2006 12:18PM
Re: Optimizing query with joins   1,673 Rob Blick 06/07/2006 10:17AM
Re: Optimizing query with joins   1,630 Rhonda Heath 02/12/2007 12:07PM
Large IN() Comparison Optimize Help   2,070 Garrett Gyssler 02/11/2007 02:51AM
How should I index the tables in this query?   2,204 Dan Bress 02/09/2007 01:35PM
Substring ignores index   6,070 Matt Ryan 09/29/2006 08:59AM
Re: Substring ignores index   3,201 Toa Sty 09/29/2006 09:48AM
Re: Substring ignores index   2,558 Denver Vender 02/09/2007 04:01AM
Help required in optimizing query   2,257 Albert Arul prakash Rajendran 02/08/2007 09:43PM
intense query with "union"   1,960 asif baloch 02/07/2007 04:54PM
my boss says mysql is not upto standard: Please reply urgent   2,063 jatin shah 02/06/2007 06:05AM
Re: my boss says mysql is not upto standard: Please reply urgent   1,627 Toa Sty 02/06/2007 09:31AM
Simple queries take a lot some times   2,019 Paolo Ragone 01/30/2007 01:04PM
ORDER BY + LIMIT   4,098 Markus Doppelbauer 11/12/2006 04:45AM
Re: ORDER BY + LIMIT   2,894 Toa Sty 11/12/2006 08:27AM
Re: ORDER BY + LIMIT   2,619 Markus Doppelbauer 11/12/2006 12:09PM
Re: ORDER BY + LIMIT   28,713 Toa Sty 11/13/2006 04:40AM
Re: ORDER BY + LIMIT   3,307 Markus Doppelbauer 01/30/2007 12:06PM
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.