Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Utilities 1.6.2 Beta has been released 08/31/2015 02:28PM
MySQL Enterprise Monitor 3.0.24 has been released 08/28/2015 01:07PM
MySQL Connector/NET 6.9.7 has been released 08/05/2015 06:38AM
MySQL Community Server 5.7.8 has been released (part 3/3) 08/03/2015 09:14AM
MySQL Community Server 5.7.8 has been released (part 2/3) 08/03/2015 09:12AM
Current Page: 12 of 17
Subject Views Written By Posted
Optimizer misbehaves   2,536 Drei Bit 07/04/2007 05:16AM
Re: Optimizer misbehaves   2,022 KimSeong Loh 07/04/2007 07:26AM
Re: Optimizer misbehaves   1,933 Drei Bit 07/04/2007 10:37AM
Variable where index optimizing   2,382 alex jordanov 06/29/2007 04:37AM
How to optimize this program? Thanks   2,263 li grewat 06/28/2007 08:31PM
Star joins?   2,637 Seth Grimes 01/17/2006 08:57PM
Re: Star joins?   2,015 Seth Grimes 01/26/2006 11:35AM
Re: Star joins?   2,082 Jay Pipes 01/26/2006 01:00PM
Re: Star joins?   1,948 Seth Grimes 01/21/2006 07:32PM
Re: Star joins?   2,705 Timour Katchaounov 01/23/2006 04:10PM
Re: Star joins?   3,993 Jag Singh 06/28/2007 04:23AM
Re: Star joins?   2,062 Peter Welker 12/09/2006 06:25AM
Re: Star joins?   2,004 Jay Pipes 01/22/2006 03:22PM
Re: Star joins?   2,064 Jay Pipes 01/18/2006 10:39PM
Re: Star joins?   1,941 Jay Pipes 01/18/2006 10:41PM
Re: Star joins?   1,934 Seth Grimes 01/20/2006 03:08PM
Re: Star joins?   2,097 Jay Pipes 01/20/2006 06:42PM
how to store 10GB data in a table(using mysql 5.0.24).   3,175 justin jose 05/02/2007 10:39PM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,171 Olexandr Novosad 05/26/2007 03:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,091 Peter Steiner 06/25/2007 07:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,187 KimSeong Loh 05/27/2007 03:00AM
How to optimize this trigger?   3,290 li grewat 06/21/2007 08:18PM
Re: How to optimize this trigger?   1,919 KimSeong Loh 06/22/2007 05:49AM
Re: How to optimize this trigger?   1,911 li grewat 06/24/2007 06:22PM
Please help:The performance of before insert trigger and after insert trigger?   2,305 li grewat 06/23/2007 06:40AM
Index optimizations for huge table   2,631 Mennan Kara 04/30/2007 08:57PM
Re: Index optimizations for huge table   1,950 Sergey Petrunya 05/22/2007 03:38PM
Index fields order   2,741 Andrey Kondakov 05/14/2007 08:35AM
Re: Index fields order   1,842 Sergey Petrunya 05/22/2007 03:19PM
Re: Index fields order   1,855 Andrey Kondakov 05/14/2007 09:14AM
Functions in the where clause   3,656 John Dzilvelis 05/21/2007 10:26AM
Re: Functions in the where clause   2,195 Timour Katchaounov 05/22/2007 04:50AM
datetime vs date,time   7,887 Alberto González 05/16/2007 02:31AM
Re: datetime vs date,time   2,718 KimSeong Loh 05/17/2007 06:08AM
Re: datetime vs date,time   2,599 Alberto González 05/17/2007 10:08AM
Re: datetime vs date,time   3,209 Jonathan Webb 05/17/2007 05:07AM
Use of join buffer is now visible in EXPLAIN   2,349 Edwin DeSouza 05/15/2007 10:21PM
Index distribution stats   1,955 Gabriel Tataranu 05/12/2007 09:54PM
Re: Index distribution stats   1,798 Gabriel Tataranu 05/13/2007 05:42PM
Optimising query with self-join and GROUP BY   6,877 Richard Fairhurst 05/07/2007 01:24PM
Re: Optimising query with self-join and GROUP BY   2,918 Björn Steinbrink 05/09/2007 05:21PM
Re: Optimising query with self-join and GROUP BY   2,219 Richard Fairhurst 05/13/2007 03:12PM
select + order by + limit 0,1   6,137 Markus Doppelbauer 05/11/2007 01:10AM
Re: select + order by + limit 0,1   2,348 Markus Doppelbauer 05/11/2007 01:22AM
How to optimize I/O?   2,378 gpslocator 05/09/2007 09:41PM
Huge amount of data   3,470 Sebastien Salou 04/25/2007 02:47AM
Re: Huge amount of data   1,851 KimSeong Loh 04/29/2007 10:23PM
Re: Huge amount of data   1,830 justin jose 05/02/2007 10:37PM
Need to optimise complex query   2,397 Ben Sebborn 04/29/2007 04:13PM
Re: Need to optimise complex query   1,746 KimSeong Loh 04/29/2007 10:21PM
Re: Need to optimise complex query   1,718 Ben Sebborn 04/30/2007 05:00AM
Re: Need to optimise complex query   1,778 KimSeong Loh 04/30/2007 08:36PM
Random-row queries   4,541 James Yopp 04/29/2007 06:35PM
how to create the index for three fields?   2,646 justin ux 04/24/2007 08:35PM
Query performance on indexed columns   2,117 marco rossi 04/24/2007 06:52AM
Table JOIN causes FULLSCAN despite of indeces   2,285 Denis 04/19/2007 11:58AM
CPU 99%   2,239 Neela Mahendran 04/17/2007 09:47PM
Optimizing index use in select statement   5,252 Andrey Kondakov 04/15/2007 07:23AM
Re: Optimizing index use in select statement   2,097 KimSeong Loh 04/15/2007 03:10PM
How to Control MySQL CPU Usage   2,068 TAT LIM CHIN 04/13/2007 11:39AM
Index on difference of two columns   2,943 Marty - 04/08/2007 09:31AM
Re: Index on difference of two columns   1,775 KimSeong Loh 04/11/2007 06:38AM
Re: Index on difference of two columns   1,761 Marty - 04/12/2007 12:06AM
otimize search with wildcar "%" ?   2,470 edson fernando 04/07/2007 12:02AM
Re: otimize search with wildcar "%" ?   1,654 KimSeong Loh 04/08/2007 09:01AM
help - join query optimization   2,239 Brian Kohan 04/05/2007 09:18AM
how to analyze this query_cache status   2,680 d h 03/30/2007 12:46AM
Slow Queries   2,088 Farrukh Ahmed 03/29/2007 02:32AM
Slow Subquery - Optimization in this simple query needed   3,747 elissaios 03/27/2007 11:42PM
Re: Slow Subquery - Optimization in this simple query needed   2,033 Björn Steinbrink 03/28/2007 06:22PM
Re: Slow Subquery - Optimization in this simple query needed   2,236 KimSeong Loh 03/28/2007 05:59PM
Optimize Multiple CPUs on Windows 2003 Server   2,748 Thomas Mockbee 03/28/2007 02:01PM
Limiting query research to a specified n. of records   2,367 marco rossi 03/16/2007 04:35AM
Re: Limiting query research to a specified n. of records   1,711 Björn Steinbrink 03/16/2007 09:59AM
B-Tree index ignored. Why?   5,860 Daniel Terry 03/14/2007 12:46PM
Re: B-Tree index ignored. Why?   2,388 KimSeong Loh 03/14/2007 07:39PM
Optimizing a Query   2,141 Drew Kutcharian 03/12/2007 08:45PM
Removing default NULL from table definition   2,802 Andrey Kondakov 03/11/2007 09:52AM
sql_no_cache added by the optimizer   2,863 alan langridge 03/08/2007 12:32PM
Re: sql_no_cache added by the optimizer   1,710 KimSeong Loh 03/08/2007 07:19PM
Extremely slow subqueries when used in joins   2,218 kalinda 03/08/2007 06:50AM
Optimizing Queries   2,163 Scott Pringle 03/06/2007 03:32PM
the query not optimized   2,148 Luca 03/02/2007 05:47AM
Optimizing this query slows it down   2,274 wm 02/28/2007 08:33AM
Re: Optimizing this query slows it down   1,605 KimSeong Loh 02/28/2007 06:26PM
low query   3,781 hakim benmouhoub 02/16/2007 03:49AM
Re: low query   1,631 Toa Sty 02/16/2007 04:44AM
Re: low query   1,583 ben hakim 02/16/2007 08:28AM
Re: low query   1,587 KimSeong Loh 02/25/2007 11:55PM
MySQL Optimizer Blogs by Sergey Petrunia   2,434 Edwin DeSouza 02/24/2007 12:54AM
how to explain this table status   2,274 rei 02/06/2007 04:33AM
Re: how to explain this table status   1,655 rei 02/22/2007 08:23PM
Large database   2,652 Omar Khan 01/12/2007 07:45AM
Re: Large database   1,822 Albert Arul prakash Rajendran 02/09/2007 01:42AM
Re: Large database   1,596 Omar Khan 02/14/2007 06:55AM
Re: Large database   1,835 KimSeong Loh 02/14/2007 06:47PM
Re: Large database   1,743 Omar Khan 02/15/2007 05:35AM
Re: Large database   1,849 Sean Allin 02/15/2007 05:13PM
Indexing for queries including count   2,029 Omar Khan 02/14/2007 07:05AM
Retrieved columns affects index usage   2,118 Angus 02/13/2007 12:06PM
Re: Retrieved columns affects index usage   1,604 KimSeong Loh 02/13/2007 06:37PM
force index on text & integer joiin   3,484 Simon Cranmer 02/12/2007 11:31AM
Re: force index on text & integer joiin   1,771 KimSeong Loh 02/12/2007 07:35PM
Re: force index on text & integer joiin   1,882 Simon Cranmer 02/13/2007 07:54AM
Optimizing query with joins   2,549 kayne 06/03/2006 12:18PM
Re: Optimizing query with joins   1,684 Rob Blick 06/07/2006 10:17AM
Re: Optimizing query with joins   1,643 Rhonda Heath 02/12/2007 12:07PM
Large IN() Comparison Optimize Help   2,110 Garrett Gyssler 02/11/2007 02:51AM
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.