MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL for Visual Studio 2.0.5 m4 release has been released 04/25/2017 04:25AM
MySQL Connector/Python 2.1.6 GA has been released 04/18/2017 08:49AM
MySQL Router 2.1.3 GA has been released 04/12/2017 12:17PM
MySQL Shell 1.0.9 GA has been released 04/12/2017 12:16PM
MySQL Cluster 7.5.6 has been released 04/11/2017 02:22AM
Current Page: 12 of 17
Subject Views Written By Posted
Want ORDER BY to use indexed portion of long text field   5,731 Bob Fitterman 10/13/2007 07:03AM
Re: Want ORDER BY to use indexed portion of long text field   2,439 KimSeong Loh 11/15/2007 03:51PM
Re: Want ORDER BY to use indexed portion of long text field   2,594 Chris Schneider 10/24/2007 03:06PM
Re: Want ORDER BY to use indexed portion of long text field   2,624 Bob Fitterman 11/15/2007 09:20AM
optimze for a mysql server - my.cnf   4,431 kean galileo 11/06/2007 06:26PM
Making the EXPLAIN EXTENDED query runnable   3,145 Niklas Saers 10/31/2007 07:07AM
closing DB policy   2,815 Danny Jaworski 10/30/2007 02:52AM
inner join on key does full table scan anyway   4,891 Doug Perham 10/26/2007 06:34AM
Re: inner join on key does full table scan anyway   2,590 Chris Schneider 10/26/2007 01:21PM
Priority & Timeout   4,991 Jonathan Isaac 08/20/2007 11:36AM
Re: Priority & Timeout   3,017 Chris Schneider 10/24/2007 03:12PM
Problem with result field list   3,003 Adrian Chapela Cordeiro 10/02/2007 10:40AM
Re: Problem with result field list   2,027 Chris Schneider 10/24/2007 02:54PM
Aggregate function optimization for same column in same record   3,680 Nathan Alden 10/07/2007 10:30PM
ORDER BY ... LIMIT   3,564 Ed Mazur 09/27/2007 11:24AM
Re: ORDER BY ... LIMIT   2,332 KimSeong Loh 09/27/2007 05:07PM
How to speed up my DB   2,779 Venkateswaran Nagarajan 09/21/2007 09:05PM
Query execution time depends on the size of the tables????????????   3,027 Venkateswaran Nagarajan 09/21/2007 08:56PM
multiple index is used only partially   4,043 Miguel Balsevich 09/08/2007 03:37PM
Re: multiple index is used only partially   2,388 Miguel Balsevich 09/11/2007 08:04AM
Using FileSort   3,731 Clement Ho 09/10/2007 05:21PM
Help join optimisation   2,765 Catia Lavalle 09/05/2007 05:41AM
Can I speed this up?   4,783 Eljakim Schrijvers 02/17/2007 11:18AM
Re: Can I speed this up?   2,620 Adrian Chapela Cordeiro 08/30/2007 02:55AM
Re: Can I speed this up?   2,736 KimSeong Loh 02/25/2007 11:40PM
Re: Can I speed this up?   2,715 Eljakim Schrijvers 03/10/2007 01:23PM
Re: Can I speed this up?   2,661 KimSeong Loh 03/11/2007 12:59AM
Re: Can I speed this up?   2,689 Dian Kresno 04/26/2007 01:04AM
Re: Can I speed this up?   2,881 Eljakim Schrijvers 02/17/2007 11:23AM
time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables   4,948 Jan Theodore Galkowski 06/27/2007 08:52AM
Re: time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables   2,847 Adrian Chapela Cordeiro 08/30/2007 02:13AM
LEFT JOIN Optimization   7,354 Ram R 08/21/2007 03:04PM
Re: LEFT JOIN Optimization   3,674 KimSeong Loh 08/21/2007 06:45PM
Re: LEFT JOIN Optimization   2,952 Adrian Chapela Cordeiro 08/29/2007 03:55AM
Re: LEFT JOIN Optimization   3,216 Ram R 08/21/2007 11:32PM
Re: LEFT JOIN Optimization   3,185 KimSeong Loh 08/29/2007 07:19PM
A popular forum not able to take load.. my.cnf optimization needed   7,215 Raman Singh 08/12/2007 12:48AM
Re: A popular forum not able to take load.. my.cnf optimization needed   2,614 Adrian Chapela Cordeiro 08/29/2007 04:50AM
Re: A popular forum not able to take load.. my.cnf optimization needed   2,669 KimSeong Loh 08/12/2007 05:17PM
Optimized query still way too slow   3,139 Brad Douglas 08/13/2007 04:54PM
Speed up query execution with 30Million rows   6,680 Vibhu Bansal 08/09/2007 06:40AM
Re: Speed up query execution with 30Million rows   3,226 Yogesh Salvi 08/13/2007 05:46AM
How to optimize this query?   3,962 Kwang Chin Lee 06/20/2007 07:38AM
Re: How to optimize this query?   2,134 Yogesh Salvi 08/13/2007 05:43AM
How to stop temporary table in this query   3,422 Mike Zupan 08/09/2007 11:19AM
Indexing table takes 4 hours   2,701 Francisco Cha 08/08/2007 03:11PM
Help requested optimising query with subquery   2,860 Christian Seaman 08/08/2007 06:21AM
Re: Help requested optimising query with subquery   2,022 KimSeong Loh 08/08/2007 07:01AM
Need some help to optimize a query with multiple JOIN   6,181 Jean-Baptiste ANNE 07/30/2007 01:42PM
Re: Need some help to optimize a query with multiple JOIN   2,734 Sergey Belov 07/31/2007 05:55AM
Re: Need some help to optimize a query with multiple JOIN   2,661 Jean-Baptiste ANNE 07/31/2007 10:20AM
Re: Need some help to optimize a query with multiple JOIN   2,609 Sergey Belov 08/01/2007 01:12AM
Re: Need some help to optimize a query with multiple JOIN   2,725 Jean-Baptiste ANNE 08/01/2007 07:58AM
Re: Need some help to optimize a query with multiple JOIN   2,789 KimSeong Loh 08/05/2007 01:03AM
why does explain plan change?   10,979 charlie w 07/30/2007 10:14AM
Re: why does explain plan change?   2,920 Fabio Sgamo 08/03/2007 05:22AM
Problem with optimization of a WHERE clause   3,337 Giorgio Calderone 08/02/2007 12:41PM
Can't understand why optimizer doesn't work properly :(   2,945 Sergey Belov 07/23/2007 02:03PM
Re: Can't understand why optimizer doesn't work properly :(   2,083 KimSeong Loh 07/23/2007 07:21PM
Re: Can't understand why optimizer doesn't work properly :(   2,150 Sergey Belov 07/24/2007 12:26AM
Re: Can't understand why optimizer doesn't work properly :(   2,006 KimSeong Loh 07/24/2007 02:08AM
Re: Can't understand why optimizer doesn't work properly :(   2,213 Sergey Belov 07/24/2007 02:42AM
Re: Can't understand why optimizer doesn't work properly :(   1,972 KimSeong Loh 07/24/2007 06:02PM
Re: Can't understand why optimizer doesn't work properly :(   2,070 Sergey Belov 07/25/2007 11:10PM
Optimizing a search query   2,611 Staffan S 07/25/2007 03:58AM
Index evaluation   3,065 Drei Bit 07/23/2007 04:51PM
Re: Index evaluation   2,142 KimSeong Loh 07/23/2007 07:27PM
Re: Index evaluation   2,087 Drei Bit 07/24/2007 05:24AM
Re: Index evaluation   2,059 Drei Bit 07/23/2007 05:18PM
Re: Index evaluation   2,089 KimSeong Loh 07/24/2007 02:06AM
Re: Index evaluation   2,044 Drei Bit 07/24/2007 04:33AM
Profiling only works in MySQL 5.0.37?   3,755 Suave Su 07/19/2007 12:22AM
Re: Profiling only works in MySQL 5.0.37?   2,254 KimSeong Loh 07/19/2007 05:02AM
Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   5,048 Drei Bit 07/03/2007 05:37PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,257 KimSeong Loh 07/04/2007 06:45AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,219 Drei Bit 07/04/2007 10:49AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,243 KimSeong Loh 07/05/2007 01:14AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,186 Drei Bit 07/05/2007 03:22AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,210 KimSeong Loh 07/05/2007 03:16PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,186 Drei Bit 07/10/2007 09:37AM
join order when using order by   5,834 Christopher Cudennec 07/09/2007 07:54AM
default order by   4,266 Joel Webb 07/06/2007 08:49AM
Cost Model Information   2,795 Drei Bit 07/05/2007 03:26AM
Optimizer misbehaves   2,745 Drei Bit 07/04/2007 05:16AM
Re: Optimizer misbehaves   2,145 KimSeong Loh 07/04/2007 07:26AM
Re: Optimizer misbehaves   2,044 Drei Bit 07/04/2007 10:37AM
Variable where index optimizing   2,532 alex jordanov 06/29/2007 04:37AM
How to optimize this program? Thanks   2,457 li grewat 06/28/2007 08:31PM
Star joins?   2,830 Seth Grimes 01/17/2006 08:57PM
Re: Star joins?   2,106 Seth Grimes 01/26/2006 11:35AM
Re: Star joins?   2,202 Jay Pipes 01/26/2006 01:00PM
Re: Star joins?   2,047 Seth Grimes 01/21/2006 07:32PM
Re: Star joins?   2,931 Timour Katchaounov 01/23/2006 04:10PM
Re: Star joins?   4,368 Jag Singh 06/28/2007 04:23AM
Re: Star joins?   2,165 Peter Welker 12/09/2006 06:25AM
Re: Star joins?   2,107 Jay Pipes 01/22/2006 03:22PM
Re: Star joins?   2,202 Jay Pipes 01/18/2006 10:39PM
Re: Star joins?   2,053 Jay Pipes 01/18/2006 10:41PM
Re: Star joins?   2,081 Seth Grimes 01/20/2006 03:08PM
Re: Star joins?   2,215 Jay Pipes 01/20/2006 06:42PM
how to store 10GB data in a table(using mysql 5.0.24).   3,603 justin jose 05/02/2007 10:39PM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,459 Olexandr Novosad 05/26/2007 03:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,168 Peter Steiner 06/25/2007 07:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,289 KimSeong Loh 05/27/2007 03:00AM
How to optimize this trigger?   3,788 li grewat 06/21/2007 08:18PM
Re: How to optimize this trigger?   2,045 KimSeong Loh 06/22/2007 05:49AM
Re: How to optimize this trigger?   2,019 li grewat 06/24/2007 06:22PM
Please help:The performance of before insert trigger and after insert trigger?   2,429 li grewat 06/23/2007 06:40AM
Index optimizations for huge table   2,802 Mennan Kara 04/30/2007 08:57PM
Re: Index optimizations for huge table   2,163 Sergey Petrunya 05/22/2007 03:38PM
Index fields order   2,933 Andrey Kondakov 05/14/2007 08:35AM
Re: Index fields order   1,896 Sergey Petrunya 05/22/2007 03:19PM
Re: Index fields order   1,963 Andrey Kondakov 05/14/2007 09:14AM
Functions in the where clause   3,846 John Dzilvelis 05/21/2007 10:26AM
Re: Functions in the where clause   2,279 Timour Katchaounov 05/22/2007 04:50AM
datetime vs date,time   8,321 Alberto González 05/16/2007 02:31AM
Re: datetime vs date,time   2,839 KimSeong Loh 05/17/2007 06:08AM
Re: datetime vs date,time   2,679 Alberto González 05/17/2007 10:08AM
Re: datetime vs date,time   3,298 Jonathan Webb 05/17/2007 05:07AM
Use of join buffer is now visible in EXPLAIN   2,501 Edwin DeSouza 05/15/2007 10:21PM
Index distribution stats   2,236 Gabriel Tataranu 05/12/2007 09:54PM
Re: Index distribution stats   1,885 Gabriel Tataranu 05/13/2007 05:42PM
Optimising query with self-join and GROUP BY   7,492 Richard Fairhurst 05/07/2007 01:24PM
Re: Optimising query with self-join and GROUP BY   3,032 Björn Steinbrink 05/09/2007 05:21PM
Re: Optimising query with self-join and GROUP BY   2,306 Richard Fairhurst 05/13/2007 03:12PM
select + order by + limit 0,1   6,384 Markus Doppelbauer 05/11/2007 01:10AM
Re: select + order by + limit 0,1   2,435 Markus Doppelbauer 05/11/2007 01:22AM
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.