MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.3 GA has been released 09/15/2016 03:06PM
MySQL Connector/Python 2.2.1 m2 Development Release has been released 09/13/2016 09:58AM
Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 has been released 09/12/2016 02:59PM
MySQL Community Server 8.0.0-dmr has been released (part 3/3) 09/12/2016 08:52AM
MySQL Community Server 8.0.0-dmr has been released (part 2/3) 09/12/2016 08:50AM
Current Page: 12 of 17
Subject Views Written By Posted
Speed up query execution with 30Million rows   6,622 Vibhu Bansal 08/09/2007 06:40AM
Re: Speed up query execution with 30Million rows   3,174 Yogesh Salvi 08/13/2007 05:46AM
How to optimize this query?   3,859 Kwang Chin Lee 06/20/2007 07:38AM
Re: How to optimize this query?   2,107 Yogesh Salvi 08/13/2007 05:43AM
How to stop temporary table in this query   3,350 Mike Zupan 08/09/2007 11:19AM
Indexing table takes 4 hours   2,628 Francisco Cha 08/08/2007 03:11PM
Help requested optimising query with subquery   2,805 Christian Seaman 08/08/2007 06:21AM
Re: Help requested optimising query with subquery   1,996 KimSeong Loh 08/08/2007 07:01AM
Need some help to optimize a query with multiple JOIN   6,137 Jean-Baptiste ANNE 07/30/2007 01:42PM
Re: Need some help to optimize a query with multiple JOIN   2,706 Sergey Belov 07/31/2007 05:55AM
Re: Need some help to optimize a query with multiple JOIN   2,599 Jean-Baptiste ANNE 07/31/2007 10:20AM
Re: Need some help to optimize a query with multiple JOIN   2,588 Sergey Belov 08/01/2007 01:12AM
Re: Need some help to optimize a query with multiple JOIN   2,677 Jean-Baptiste ANNE 08/01/2007 07:58AM
Re: Need some help to optimize a query with multiple JOIN   2,730 KimSeong Loh 08/05/2007 01:03AM
why does explain plan change?   10,599 charlie w 07/30/2007 10:14AM
Re: why does explain plan change?   2,844 Fabio Sgamo 08/03/2007 05:22AM
Problem with optimization of a WHERE clause   3,249 Giorgio Calderone 08/02/2007 12:41PM
Can't understand why optimizer doesn't work properly :(   2,864 Sergey Belov 07/23/2007 02:03PM
Re: Can't understand why optimizer doesn't work properly :(   2,033 KimSeong Loh 07/23/2007 07:21PM
Re: Can't understand why optimizer doesn't work properly :(   2,124 Sergey Belov 07/24/2007 12:26AM
Re: Can't understand why optimizer doesn't work properly :(   1,986 KimSeong Loh 07/24/2007 02:08AM
Re: Can't understand why optimizer doesn't work properly :(   2,182 Sergey Belov 07/24/2007 02:42AM
Re: Can't understand why optimizer doesn't work properly :(   1,949 KimSeong Loh 07/24/2007 06:02PM
Re: Can't understand why optimizer doesn't work properly :(   2,048 Sergey Belov 07/25/2007 11:10PM
Optimizing a search query   2,558 Staffan S 07/25/2007 03:58AM
Index evaluation   2,988 Drei Bit 07/23/2007 04:51PM
Re: Index evaluation   2,110 KimSeong Loh 07/23/2007 07:27PM
Re: Index evaluation   2,060 Drei Bit 07/24/2007 05:24AM
Re: Index evaluation   2,031 Drei Bit 07/23/2007 05:18PM
Re: Index evaluation   2,060 KimSeong Loh 07/24/2007 02:06AM
Re: Index evaluation   2,008 Drei Bit 07/24/2007 04:33AM
Profiling only works in MySQL 5.0.37?   3,651 Suave Su 07/19/2007 12:22AM
Re: Profiling only works in MySQL 5.0.37?   2,224 KimSeong Loh 07/19/2007 05:02AM
Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   4,935 Drei Bit 07/03/2007 05:37PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,225 KimSeong Loh 07/04/2007 06:45AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,190 Drei Bit 07/04/2007 10:49AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,157 KimSeong Loh 07/05/2007 01:14AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,148 Drei Bit 07/05/2007 03:22AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,105 KimSeong Loh 07/05/2007 03:16PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,152 Drei Bit 07/10/2007 09:37AM
join order when using order by   5,644 Christopher Cudennec 07/09/2007 07:54AM
default order by   4,157 Joel Webb 07/06/2007 08:49AM
Cost Model Information   2,658 Drei Bit 07/05/2007 03:26AM
Optimizer misbehaves   2,671 Drei Bit 07/04/2007 05:16AM
Re: Optimizer misbehaves   2,069 KimSeong Loh 07/04/2007 07:26AM
Re: Optimizer misbehaves   1,984 Drei Bit 07/04/2007 10:37AM
Variable where index optimizing   2,480 alex jordanov 06/29/2007 04:37AM
How to optimize this program? Thanks   2,396 li grewat 06/28/2007 08:31PM
Star joins?   2,754 Seth Grimes 01/17/2006 08:57PM
Re: Star joins?   2,079 Seth Grimes 01/26/2006 11:35AM
Re: Star joins?   2,165 Jay Pipes 01/26/2006 01:00PM
Re: Star joins?   2,019 Seth Grimes 01/21/2006 07:32PM
Re: Star joins?   2,810 Timour Katchaounov 01/23/2006 04:10PM
Re: Star joins?   4,170 Jag Singh 06/28/2007 04:23AM
Re: Star joins?   2,128 Peter Welker 12/09/2006 06:25AM
Re: Star joins?   2,073 Jay Pipes 01/22/2006 03:22PM
Re: Star joins?   2,151 Jay Pipes 01/18/2006 10:39PM
Re: Star joins?   2,010 Jay Pipes 01/18/2006 10:41PM
Re: Star joins?   2,014 Seth Grimes 01/20/2006 03:08PM
Re: Star joins?   2,179 Jay Pipes 01/20/2006 06:42PM
how to store 10GB data in a table(using mysql 5.0.24).   3,326 justin jose 05/02/2007 10:39PM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,271 Olexandr Novosad 05/26/2007 03:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,137 Peter Steiner 06/25/2007 07:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,254 KimSeong Loh 05/27/2007 03:00AM
How to optimize this trigger?   3,486 li grewat 06/21/2007 08:18PM
Re: How to optimize this trigger?   2,010 KimSeong Loh 06/22/2007 05:49AM
Re: How to optimize this trigger?   1,991 li grewat 06/24/2007 06:22PM
Please help:The performance of before insert trigger and after insert trigger?   2,380 li grewat 06/23/2007 06:40AM
Index optimizations for huge table   2,760 Mennan Kara 04/30/2007 08:57PM
Re: Index optimizations for huge table   2,031 Sergey Petrunya 05/22/2007 03:38PM
Index fields order   2,870 Andrey Kondakov 05/14/2007 08:35AM
Re: Index fields order   1,875 Sergey Petrunya 05/22/2007 03:19PM
Re: Index fields order   1,901 Andrey Kondakov 05/14/2007 09:14AM
Functions in the where clause   3,770 John Dzilvelis 05/21/2007 10:26AM
Re: Functions in the where clause   2,244 Timour Katchaounov 05/22/2007 04:50AM
datetime vs date,time   8,193 Alberto González 05/16/2007 02:31AM
Re: datetime vs date,time   2,785 KimSeong Loh 05/17/2007 06:08AM
Re: datetime vs date,time   2,641 Alberto González 05/17/2007 10:08AM
Re: datetime vs date,time   3,268 Jonathan Webb 05/17/2007 05:07AM
Use of join buffer is now visible in EXPLAIN   2,439 Edwin DeSouza 05/15/2007 10:21PM
Index distribution stats   2,065 Gabriel Tataranu 05/12/2007 09:54PM
Re: Index distribution stats   1,853 Gabriel Tataranu 05/13/2007 05:42PM
Optimising query with self-join and GROUP BY   7,283 Richard Fairhurst 05/07/2007 01:24PM
Re: Optimising query with self-join and GROUP BY   2,996 Björn Steinbrink 05/09/2007 05:21PM
Re: Optimising query with self-join and GROUP BY   2,276 Richard Fairhurst 05/13/2007 03:12PM
select + order by + limit 0,1   6,280 Markus Doppelbauer 05/11/2007 01:10AM
Re: select + order by + limit 0,1   2,395 Markus Doppelbauer 05/11/2007 01:22AM
How to optimize I/O?   2,489 gpslocator 05/09/2007 09:41PM
Huge amount of data   3,579 Sebastien Salou 04/25/2007 02:47AM
Re: Huge amount of data   1,898 KimSeong Loh 04/29/2007 10:23PM
Re: Huge amount of data   1,901 justin jose 05/02/2007 10:37PM
Need to optimise complex query   2,601 Ben Sebborn 04/29/2007 04:13PM
Re: Need to optimise complex query   1,801 KimSeong Loh 04/29/2007 10:21PM
Re: Need to optimise complex query   1,790 Ben Sebborn 04/30/2007 05:00AM
Re: Need to optimise complex query   1,852 KimSeong Loh 04/30/2007 08:36PM
Random-row queries   4,864 James Yopp 04/29/2007 06:35PM
how to create the index for three fields?   2,874 justin ux 04/24/2007 08:35PM
Query performance on indexed columns   2,290 marco rossi 04/24/2007 06:52AM
Table JOIN causes FULLSCAN despite of indeces   2,425 Denis 04/19/2007 11:58AM
CPU 99%   2,355 Neela Mahendran 04/17/2007 09:47PM
Optimizing index use in select statement   5,420 Andrey Kondakov 04/15/2007 07:23AM
Re: Optimizing index use in select statement   2,141 KimSeong Loh 04/15/2007 03:10PM
How to Control MySQL CPU Usage   2,162 TAT LIM CHIN 04/13/2007 11:39AM
Index on difference of two columns   3,067 Marty - 04/08/2007 09:31AM
Re: Index on difference of two columns   1,840 KimSeong Loh 04/11/2007 06:38AM
Re: Index on difference of two columns   1,826 Marty - 04/12/2007 12:06AM
otimize search with wildcar "%" ?   2,590 edson fernando 04/07/2007 12:02AM
Re: otimize search with wildcar "%" ?   1,691 KimSeong Loh 04/08/2007 09:01AM
help - join query optimization   2,331 Brian Kohan 04/05/2007 09:18AM
how to analyze this query_cache status   2,795 d h 03/30/2007 12:46AM
Slow Queries   2,188 Farrukh Ahmed 03/29/2007 02:32AM
Slow Subquery - Optimization in this simple query needed   3,871 elissaios 03/27/2007 11:42PM
Re: Slow Subquery - Optimization in this simple query needed   2,076 Björn Steinbrink 03/28/2007 06:22PM
Re: Slow Subquery - Optimization in this simple query needed   2,286 KimSeong Loh 03/28/2007 05:59PM
Optimize Multiple CPUs on Windows 2003 Server   2,852 Thomas Mockbee 03/28/2007 02:01PM
Limiting query research to a specified n. of records   2,495 marco rossi 03/16/2007 04:35AM
Re: Limiting query research to a specified n. of records   1,784 Björn Steinbrink 03/16/2007 09:59AM
B-Tree index ignored. Why?   6,174 Daniel Terry 03/14/2007 12:46PM
Re: B-Tree index ignored. Why?   2,440 KimSeong Loh 03/14/2007 07:39PM
Current Page: 12 of 17

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.