Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
• MySQL Connector/Python 1.0.10 has been released 05/07/2013 12:33AM
• MySQL Connector/J 5.1.25 has been released 05/06/2013 10:30AM
• MySQL Connector/C 6.1.0 has been released 05/02/2013 02:28PM
• MySQL Connector/ODBC 5.2.5 has been released 05/02/2013 02:26PM
• MySQL for Excel 1.1.1 (GA) has been released 04/26/2013 04:33PM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
Subject Views Written By Posted
Range query performance question   4,672 Camelia Ticau 02/27/2006 01:52PM
Re: Range query performance question   2,051 Jay Pipes 02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')   24,031 yoderek 02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')   10,734 Jay Pipes 02/23/2006 11:12PM
Need recommendation regarding IN expression   1,958 Solon Barns 02/22/2006 12:52PM
Re: Need recommendation regarding IN expression   1,476 Jay Pipes 02/22/2006 01:29PM
Re: Need recommendation regarding IN expression   1,275 Solon Barns 02/23/2006 12:59AM
Re: Need recommendation regarding IN expression   1,470 Jay Pipes 02/23/2006 10:55AM
slow subquery   4,414 Michael Schnell 12/01/2005 03:33AM
Re: slow subquery   4,389 Olaf van der Spek 02/23/2006 08:04AM
Re: slow subquery   1,982 mysql.com 02/22/2006 01:06PM
Re: slow subquery   2,015 Igor Babaev 12/19/2005 11:58PM
Re: slow subquery   2,040 Matthias Horn 12/30/2005 12:43PM
Re: slow subquery (query is fast)   2,704 Matthias Horn 12/30/2005 02:25PM
Re: slow subquery   2,027 Michael Schnell 12/09/2005 02:32PM
Re: slow subquery   2,146 Brian Moon 12/07/2005 08:18AM
possible_keys exist but key is NULL   5,860 David McLaughlin 02/22/2006 11:29AM
Re: possible_keys exist but key is NULL   3,250 Thomas CORBIERE 02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY   1,762 Robert Bergs 02/21/2006 07:00AM
what is sql.exe doing?   2,543 Zilan Ciftci 02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN   1,393 Odimar Tomazeli 02/17/2006 01:37PM
Subquery performance improvements: When?   3,764 Olaf van der Spek 02/08/2006 10:07AM
Re: Subquery performance improvements: When?   1,915 Olaf van der Spek 02/14/2006 08:31AM
Re: Subquery performance improvements: When?   1,928 Robin Schumacher 02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24   1,995 Robert van Twillert 02/13/2006 12:47PM
SUBQUERY PROBLEM   2,072 Odimar Tomazeli 02/07/2006 04:21PM
Re: SUBQUERY PROBLEM   1,478 Odimar Tomazeli 02/13/2006 12:16PM
Re: SUBQUERY PROBLEM   1,532 Odimar Tomazeli 02/13/2006 11:17AM
Re: SUBQUERY PROBLEM   1,552 Jay Pipes 02/13/2006 11:22AM
Re: SUBQUERY PROBLEM   1,652 Odimar Tomazeli 02/13/2006 11:06AM
Re: SUBQUERY PROBLEM   1,480 Odimar Tomazeli 02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team   1,504 Odimar Tomazeli 02/08/2006 10:26AM
Re: SUBQUERY PROBLEM   1,593 Robin Schumacher 02/08/2006 04:57AM
Re: SUBQUERY PROBLEM   1,483 Jay Pipes 02/08/2006 03:59PM
Re: SUBQUERY PROBLEM   1,620 Jay Pipes 02/07/2006 04:45PM
Re: SUBQUERY PROBLEM   1,495 Jay Pipes 02/07/2006 04:52PM
Subqueries too slow   4,029 Andreas Schlicker 02/06/2006 11:08AM
Re: Subqueries too slow   1,702 Andreas Schlicker 02/10/2006 09:49AM
Re: Subqueries too slow   1,697 Jay Pipes 02/10/2006 10:43AM
Re: Subqueries too slow   1,663 Andreas Schlicker 02/10/2006 03:18AM
Re: Subqueries too slow   1,654 Jay Pipes 02/10/2006 08:51AM
Re: Subqueries too slow   1,845 Andreas Schlicker 02/07/2006 08:38AM
Re: Subqueries too slow   1,891 Robin Schumacher 02/06/2006 02:17PM
Re: Subqueries too slow   1,756 Andreas Schlicker 02/07/2006 07:06AM
Re: Subqueries too slow   2,034 Jay Pipes 02/06/2006 11:54AM
Is this query optimized?   1,706 zaw sze 02/09/2006 09:44PM
Question about Handler_write   2,270 Sebastien Caisse 02/09/2006 09:42AM
clash between unique and index keys   3,881 Kenneth Vogt 02/08/2006 12:58AM
Re: clash between unique and index keys   2,016 Kenneth Vogt 02/09/2006 12:04AM
Re: clash between unique and index keys   2,097 Jay Pipes 02/08/2006 04:40PM
Re: clash between unique and index keys   1,990 Kenneth Vogt 02/08/2006 05:44PM
Re: clash between unique and index keys   2,042 Jay Pipes 02/08/2006 05:49PM
qcache_free_blocks   6,532 Jacky Shu 02/07/2006 08:13AM
Re: qcache_free_blocks   3,768 Jay Pipes 02/07/2006 10:10AM
Re: qcache_free_blocks   3,432 Jacky Shu 02/07/2006 12:13PM
optimize   2,145 edson fernando 01/17/2006 02:41PM
Re: optimize   1,570 Sebastien Caisse 02/02/2006 09:02AM
Re: optimize   1,576 edson fernando 01/18/2006 09:07AM
Re: optimize   1,556 KimSeong Loh 01/17/2006 06:48PM
Double Index Performance   6,625 Jawad Laraqui 01/12/2006 02:21PM
Re: Double Index Performance   2,044 Sebastien Caisse 01/16/2006 06:24AM
Re: Double Index Performance   2,171 01/16/2006 08:46AM
Re: Double Index Performance   1,994 Sebastien Caisse 01/17/2006 06:45AM
Re: Double Index Performance   2,105 Sebastien Caisse 02/01/2006 01:05PM
Re: Double Index Performance   2,579 01/13/2006 05:18PM
'where' with 'in' doesn't use index?   2,130 Vlado Kurelec 01/24/2006 05:25AM
Re: 'where' with 'in' doesn't use index?   1,588 Vlado Kurelec 02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?   1,599 Robin Schumacher 01/30/2006 04:45PM
subquery breaks optimization   1,918 Kiryll Mirnenko 01/20/2006 06:51AM
Re: subquery breaks optimization   1,581 Robin Schumacher 01/24/2006 07:14PM
mysql dont use my Index?   1,944 Johannes Fosseus 01/12/2006 08:22AM
Re: mysql dont use my Index?   1,567 Jay Pipes 01/18/2006 10:36PM
does Select values effect index selection?   2,144 ade br 01/10/2006 09:30AM
Re: does Select values effect index selection?   1,610 Jay Pipes 01/10/2006 05:04PM
Optimizing with DATE()   1,994 Paul Hartman 01/03/2006 02:28PM
Re: Optimizing with DATE()   1,571 KimSeong Loh 01/03/2006 06:53PM
Simple Query - but explain worries me   2,106 Jake Day 11/01/2005 01:26AM
Re: Simple Query - but explain worries me   1,590 Jake Day 11/01/2005 02:48AM
Re: Simple Query - but explain worries me   1,581 Konstantin Osipov 01/02/2006 05:22PM
Re: Simple Query - but explain worries me   1,611 Vangelis Katsikaros 11/01/2005 03:05AM
Re: Simple Query - but explain worries me   1,585 Jake Day 11/01/2005 05:13AM
Re: Simple Query - but explain worries me   1,572 Vangelis Katsikaros 11/01/2005 05:57AM
Re: Simple Query - but explain worries me   1,562 Jake Day 11/01/2005 07:37AM
Re: Simple Query - but explain worries me   1,612 Jake Day 11/01/2005 08:03AM
select distinct slower in 5.0 than 4.1   2,220 Saar Barhoom 12/18/2005 12:24PM
Re: select distinct slower in 5.0 than 4.1   1,611 KimSeong Loh 12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1   1,648 Peter Zaitsev 12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1   1,629 Saar Barhoom 12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1   1,639 Timour Katchaounov 12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1   1,857 Jay Pipes 12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1   1,675 Saar Barhoom 12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1   1,623 Jay Pipes 12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1   1,640 Saar Barhoom 12/21/2005 01:54AM
Range Join Performance   2,947 Lionel Horn 11/23/2005 08:47AM
Re: Range Join Performance   1,700 Jay Pipes 12/26/2005 07:56PM
Re: Range Join Performance   1,715 Igor Babaev 12/21/2005 11:10PM
does my index take effect?   2,051 zhenxing zhai 12/21/2005 03:19AM
Re: does my index take effect?   1,561 Igor Babaev 12/21/2005 11:03PM
Index merge optimization with joined tables?   2,538 Kayra Otaner 12/01/2005 11:39AM
Re: Index merge optimization with joined tables?   1,648 Igor Babaev 12/21/2005 10:54PM
Re: Index merge optimization with joined tables?   1,692 Brian Moon 12/07/2005 08:21AM
Re: Index merge optimization with joined tables?   1,710 Jay Pipes 12/07/2005 05:37PM
explain + straight join oddity   6,989 Stuart Maclean 12/20/2005 08:06PM
Re: explain + straight join oddity   2,182 Igor Babaev 12/21/2005 10:44PM
Can't get my indexes right   2,320 Tobias Ritzau 11/26/2005 04:53PM
Re: Can't get my indexes right   1,688 Igor Babaev 12/21/2005 10:34PM
Re: Can't get my indexes right   1,665 Tobias Ritzau 11/28/2005 02:19PM
Re: Can't get my indexes right   1,578 Tobias Ritzau 11/28/2005 07:40AM
Re: Can't get my indexes right   1,704 KimSeong Loh 11/28/2005 03:17AM
Re: Can't get my indexes right   1,639 Tobias Ritzau 11/28/2005 02:44AM
Re: Can't get my indexes right   1,670 KimSeong Loh 11/27/2005 07:28PM
optimization of left outer joins   3,292 Clive Cox 12/16/2005 09:25AM
Re: optimization of left outer joins   1,767 Igor Babaev 12/19/2005 11:42PM
Re: optimization of left outer joins   1,992 Jay Pipes 12/16/2005 10:23AM
MySQL 5.0 optimizer: loose scans   2,118 Edwin DeSouza 12/19/2005 01:46PM
Query Optimizer / SQL Translation   2,859 Dave Wilson 11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation   1,790 Timour Katchaounov 12/14/2005 02:55AM
Group by Optimization   4,834 Joe Genshlea 12/01/2005 08:27AM
Re: Group by Optimization   6,116 Timour Katchaounov 12/14/2005 02:36AM
Re: Group by Optimization   2,617 Jay Pipes 12/05/2005 11:29AM
Re: Group by Optimization   3,048 12/03/2005 06:07AM
Re: Group by Optimization   2,652 Jay Pipes 12/05/2005 11:32AM
Re: Group by Optimization   2,629 12/09/2005 04:53PM
How to force the optimizer to use an index in a sub-query?   4,869 Natalia Kuznesov 10/27/2005 10:43AM
Re: How to force the optimizer to use an index in a sub-query?   2,888 Francisco Wong-Li 12/01/2005 01:51PM
why don't work for my substring index?   3,190 zhenxing zhai 11/06/2005 10:09PM
Re: why don't work for my substring index?   2,180 Francisco Wong-Li 12/01/2005 01:40PM
Re: why don't work for my substring index?   1,959 zhenxing zhai 11/13/2005 09:23PM
Re: why don't work for my substring index?   2,858 Felix Geerinckx 11/07/2005 05:13AM
Re: why don't work for my substring index?   1,896 zhenxing zhai 11/09/2005 03:07AM
fast retrieval from MySQL database   2,182 Akasmika Dash 11/21/2005 05:07AM
WHERE clause processing   2,193 Maxx Kazimieszko 11/15/2005 05:20PM
Re: WHERE clause processing   1,578 KimSeong Loh 11/15/2005 07:32PM
Eternal SELECT queries   2,119 Aniceto Perez 11/15/2005 03:31AM
Re: Eternal SELECT queries   1,670 Felix Geerinckx 11/15/2005 09:20AM
Performance of Select (pk) vs Select(*) with order by   3,462 Alexander Hristov 11/07/2005 08:54AM
Re: Performance of Select (pk) vs Select(*) with order by   2,176 KimSeong Loh 11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by   1,784 KimSeong Loh 11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by   2,871 Alexander Hristov 11/08/2005 03:53AM
INNER JOIN (WHERE) vs LEFT JOIN   83,841 Veny 11/02/2005 08:12PM
Re: INNER JOIN (WHERE) vs LEFT JOIN   22,282 Sergey Petrunya 11/03/2005 05:26AM
Re: INNER JOIN (WHERE) vs LEFT JOIN   23,348 Sergey Petrunya 11/03/2005 05:18AM
Optimizer - subqueries   3,029 Jake Day 11/01/2005 09:59AM
Re: Optimizer - subqueries   1,824 Felix Geerinckx 11/02/2005 03:52AM
Re: Optimizer - subqueries   1,705 Jake Day 11/02/2005 08:50AM
Does SELECT DISTINCT on an indexed column do an index scan?   6,322 Boris Burtin 10/31/2005 03:45PM
Re: Does SELECT DISTINCT on an indexed column do an index scan?   3,594 Sergey Petrunya 11/01/2005 12:56PM
Query optimizer fails terribly.   2,057 Kostas Chatzikokolakis 10/12/2005 11:48AM
Rows Examined, why so many?   7,635 matt roberts 09/20/2005 12:15PM
Re: Rows Examined, why so many?   2,626 KimSeong Loh 09/20/2005 07:10PM
Re: Rows Examined, why so many?   2,437 matt roberts 09/21/2005 08:13AM
Re: Rows Examined, why so many?   2,521 Jay Pipes 09/21/2005 05:05AM
Re: Rows Examined, why so many?   2,634 Jay Pipes 09/20/2005 03:54PM
Re: Rows Examined, why so many?   5,074 Daniel Nichter 09/20/2005 03:18PM
Re: Rows Examined, why so many?   3,260 matt roberts 09/21/2005 08:12AM
Optimizing ORDER BY any ideas?   3,454 Marc Van Olmen 09/06/2005 05:35PM
Re: Optimizing ORDER BY any ideas?   1,859 Jay Pipes 09/07/2005 08:55PM
Re: Optimizing ORDER BY any ideas?   1,792 Marc Van Olmen 09/08/2005 08:28AM
Re: Optimizing ORDER BY any ideas?   1,790 Jay Pipes 09/08/2005 11:12PM
Re: Optimizing ORDER BY any ideas?   1,760 Marc Van Olmen 09/09/2005 10:00AM
Re: Optimizing ORDER BY any ideas?   1,769 Marc Van Olmen 09/09/2005 10:22AM
Re: Optimizing ORDER BY any ideas?   1,690 Jay Pipes 09/09/2005 10:03PM
Re: Optimizing ORDER BY any ideas?   1,821 Marc Van Olmen 09/10/2005 07:30AM
Re: Optimizing ORDER BY any ideas?   2,268 Jay Pipes 09/10/2005 09:22AM
Re: Optimizing ORDER BY any ideas?   1,756 Marc Van Olmen 09/12/2005 02:45PM
Re: Optimizing ORDER BY any ideas?   1,739 Jay Pipes 09/12/2005 04:41PM
Re: Optimizing ORDER BY any ideas?   1,901 Jay Pipes 09/06/2005 06:39PM
Re: Optimizing ORDER BY any ideas?   2,149 Marc Van Olmen 09/06/2005 08:30PM
Re: Optimizing ORDER BY any ideas?   1,880 Jay Pipes 09/06/2005 09:18PM
Re: Optimizing ORDER BY any ideas?   1,870 Marc Van Olmen 09/07/2005 07:10AM
Re: Optimizing ORDER BY any ideas?   1,823 Marc Van Olmen 09/07/2005 06:28PM
2 column between optimization   4,453 Brad Culberson 09/02/2005 12:39PM
Re: 2 column between optimization   2,218 Jay Pipes 09/07/2005 02:48AM
Re: 2 column between optimization   2,030 Brad Culberson 09/07/2005 12:25PM
Re: 2 column between optimization   1,887 Jay Pipes 09/07/2005 12:54PM
Re: 2 column between optimization   1,922 Brad Culberson 09/06/2005 09:14PM
Re: 2 column between optimization   2,118 Jay Pipes 09/06/2005 09:22PM
Re: 2 column between optimization   1,875 Brad Culberson 09/06/2005 11:17PM
Re: 2 column between optimization   1,893 KimSeong Loh 09/07/2005 02:54AM
Re: 2 column between optimization   1,979 KimSeong Loh 09/04/2005 07:21PM
Re: 2 column between optimization   2,144 Felix Geerinckx 09/02/2005 02:01PM
Re: 2 column between optimization   2,181 Brad Culberson 09/02/2005 02:25PM
Re: 2 column between optimization   2,042 Jay Pipes 09/05/2005 12:03PM
Re: 2 column between optimization   1,940 Brad Culberson 09/06/2005 09:18PM
Re: 2 column between optimization   2,027 Felix Geerinckx 09/02/2005 03:38PM
Re: 2 column between optimization   1,984 Brad Culberson 09/06/2005 09:17PM
Unexpected benchmark results due to query optimizer?   2,258 Kees van den Broek 09/01/2005 07:38AM
Re: Unexpected benchmark results due to query optimizer?   1,773 Jay Pipes 09/01/2005 08:08AM
Re: Unexpected benchmark results due to query optimizer?   1,754 Kees van den Broek 09/07/2005 06:47AM
At Performance Limit for 2 GB RAM?   5,398 Nick Matheson 07/20/2005 09:42AM
Re: At Performance Limit for 2 GB RAM?   2,333 KimSeong Loh 07/20/2005 05:45PM
Re: At Performance Limit for 2 GB RAM?   2,213 Nick Matheson 07/22/2005 01:33PM
Re: At Performance Limit for 2 GB RAM?   2,117 Jay Pipes 07/22/2005 02:06PM
Re: At Performance Limit for 2 GB RAM?   1,893 Nick Matheson 07/26/2005 03:47PM
Re: At Performance Limit for 2 GB RAM?   1,891 Jay Pipes 07/26/2005 07:06PM
Re: At Performance Limit for 2 GB RAM?   1,936 Nick Matheson 07/27/2005 09:46AM
Re: At Performance Limit for 2 GB RAM?   1,887 KimSeong Loh 08/02/2005 12:59AM
Re: At Performance Limit for 2 GB RAM?   1,849 Nick Matheson 08/09/2005 07:57AM
Re: At Performance Limit for 2 GB RAM?   2,265 Nick Matheson 08/08/2005 09:26AM
Re: At Performance Limit for 2 GB RAM?   1,864 Jay Pipes 07/30/2005 11:44AM
Re: At Performance Limit for 2 GB RAM?   2,527 Nick Matheson 08/01/2005 11:18AM
Re: At Performance Limit for 2 GB RAM?   2,372 Jay Pipes 08/04/2005 07:17PM
Re: At Performance Limit for 2 GB RAM?   2,259 Nick Matheson 08/08/2005 09:08AM
Re: At Performance Limit for 2 GB RAM?   1,846 KimSeong Loh 07/26/2005 06:55PM
Re: At Performance Limit for 2 GB RAM?   1,903 Nick Matheson 07/25/2005 01:40PM
Re: At Performance Limit for 2 GB RAM?   2,296 Jay Pipes 07/22/2005 02:13PM
SQL syntax appears correct but EXPLAIN does not work?   3,259 David Wynter 07/10/2005 09:25AM
Re: SQL syntax appears correct but EXPLAIN does not work?   1,854 Russell Dyer 07/10/2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?   1,886 David Wynter 07/18/2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?   1,916 Jay Pipes 07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?   1,754 Jay Pipes 07/18/2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?   1,822 David Wynter 07/18/2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?   1,785 David Wynter 07/18/2005 10:54AM
Pages:  Previous First... 12 13 14 15 16 Next
Current Page: 15 of 16
powered by phorum

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.