Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
• MySQL Workbench 6.0: BETA 1 released 06/13/2013 07:45PM
• MySQL Community Server 5.1.70 has been released 06/06/2013 08:19AM
• MySQL Community Server 5.5.32 has been released 06/06/2013 07:58AM
• MySQL Community Server 5.6.12 has been released 06/06/2013 07:36AM
Current Page: 12 of 16
Subject Views Written By Posted
Retrieved columns affects index usage   1,901 Angus 02/13/2007 12:06PM
Re: Retrieved columns affects index usage   1,484 KimSeong Loh 02/13/2007 06:37PM
force index on text & integer joiin   3,276 Simon Cranmer 02/12/2007 11:31AM
Re: force index on text & integer joiin   1,671 KimSeong Loh 02/12/2007 07:35PM
Re: force index on text & integer joiin   1,742 Simon Cranmer 02/13/2007 07:54AM
Optimizing query with joins   2,344 kayne 06/03/2006 12:18PM
Re: Optimizing query with joins   1,581 Rob Blick 06/07/2006 10:17AM
Re: Optimizing query with joins   1,564 Rhonda Heath 02/12/2007 12:07PM
Large IN() Comparison Optimize Help   1,892 Garrett Gyssler 02/11/2007 02:51AM
How should I index the tables in this query?   1,951 Dan Bress 02/09/2007 01:35PM
Substring ignores index   5,722 Matt Ryan 09/29/2006 08:59AM
Re: Substring ignores index   2,982 Toa Sty 09/29/2006 09:48AM
Re: Substring ignores index   2,454 Denver Vender 02/09/2007 04:01AM
Help required in optimizing query   1,799 Albert Arul prakash Rajendran 02/08/2007 09:43PM
intense query with "union"   1,769 asif baloch 02/07/2007 04:54PM
my boss says mysql is not upto standard: Please reply urgent   1,871 jatin shah 02/06/2007 06:05AM
Re: my boss says mysql is not upto standard: Please reply urgent   1,495 Toa Sty 02/06/2007 09:31AM
Simple queries take a lot some times   1,847 Paolo Ragone 01/30/2007 01:04PM
ORDER BY + LIMIT   3,825 Markus Doppelbauer 11/12/2006 04:45AM
Re: ORDER BY + LIMIT   2,712 Toa Sty 11/12/2006 08:27AM
Re: ORDER BY + LIMIT   2,429 Markus Doppelbauer 11/12/2006 12:09PM
Re: ORDER BY + LIMIT   23,767 Toa Sty 11/13/2006 04:40AM
Re: ORDER BY + LIMIT   3,017 Markus Doppelbauer 01/30/2007 12:06PM
bug?? partial index gives wrong results with IN subquery   1,934 Paul Davies 01/29/2007 08:44AM
File Sort   1,974 aftab khan 01/25/2007 08:49AM
Re: File Sort   1,571 KimSeong Loh 01/26/2007 07:50AM
SQL Newbie needs urgently help! [optimizing query]   2,555 Toxic Head 01/24/2007 05:31AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,658 Toxic Head 01/24/2007 05:52AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,604 Toa Sty 01/24/2007 06:07AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,657 Toxic Head 01/24/2007 06:18AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,582 Toa Sty 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,752 Toxic Head 01/24/2007 07:32AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,598 Toxic Head 01/24/2007 06:41AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,562 Toxic Head 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,600 Toa Sty 01/24/2007 08:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,676 Toxic Head 01/24/2007 08:50AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,544 Toxic Head 01/24/2007 09:24AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,627 Björn Steinbrink 01/24/2007 03:19PM
Re: SQL Newbie needs urgently help! [optimizing query]   1,558 Toxic Head 01/25/2007 07:27AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,588 Toa Sty 01/24/2007 10:29AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,598 Toxic Head 01/24/2007 10:40AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,609 Toa Sty 01/24/2007 09:10AM
need solution for ORDER BY and COUNT   2,215 Konstantin S. 01/25/2007 05:46AM
Need help optmizing query   1,843 Pascual Angulo 01/16/2007 03:58PM
Re: Need help optmizing query   1,594 KimSeong Loh 01/16/2007 06:42PM
How to optimize a derived table required for re-ordering.   2,557 Vikash Bucha 11/25/2006 05:58AM
Re: How to optimize a derived table required for re-ordering.   2,244 Toa Sty 01/15/2007 08:41AM
Help optimizing a slow query entry   2,019 Patrick 01/12/2007 10:28AM
Re: Help optimizing a slow query entry   1,547 Toa Sty 01/15/2007 08:30AM
Having problems with ORDER BY COUNT   12,307 steed coptang 04/29/2006 08:56AM
Re: Having problems with ORDER BY COUNT   4,546 Omar Khan 01/15/2007 03:35AM
Re: Having problems with ORDER BY COUNT   4,022 Toa Sty 01/15/2007 08:28AM
Problems optimize query   2,643 Rafal Kedziorski 01/08/2007 05:14PM
Make this faster?   2,443 Levi Tedder 01/04/2007 07:38AM
Re: Make this faster?   1,717 Björn Steinbrink 01/04/2007 03:34PM
Re: Make this faster?   1,711 Levi Tedder 01/05/2007 02:40AM
Re: Make this faster?   1,654 Björn Steinbrink 01/05/2007 05:07AM
Re: Make this faster?   1,634 Levi Tedder 01/05/2007 08:31AM
Re: Make this faster?   1,655 Toa Sty 01/05/2007 08:45AM
Re: Make this faster?   1,677 Levi Tedder 01/08/2007 02:44AM
Re: Make this faster?   1,648 Toa Sty 01/08/2007 04:28AM
Re: Make this faster?   1,677 Levi Tedder 01/08/2007 04:41AM
Re: Make this faster?   1,710 Levi Tedder 01/05/2007 03:11PM
Re: Make this faster?   1,674 Felix Geerinckx 01/05/2007 06:55AM
Re: Make this faster?   1,668 Toa Sty 01/05/2007 08:31AM
Re: Make this faster?   1,704 Levi Tedder 01/05/2007 08:33AM
Re: Make this faster?   1,690 Toa Sty 01/05/2007 08:45AM
Re: Make this faster?   1,689 Toa Sty 01/04/2007 10:21AM
Re: Make this faster?   1,650 Levi Tedder 01/04/2007 11:51AM
REGEXP is not optimized?   2,098 Maarten Oosten 12/15/2006 07:54AM
Re: REGEXP is not optimized?   1,917 Toa Sty 01/05/2007 08:57AM
Two general MySQL questions   3,354 Joost 01/02/2007 09:24AM
Re: Two general MySQL questions   1,653 KimSeong Loh 01/02/2007 08:11PM
Re: Two general MySQL questions   1,600 Joost 01/03/2007 05:35PM
Re: Two general MySQL questions   1,623 KimSeong Loh 01/03/2007 06:10PM
Re: Two general MySQL questions   1,640 Joost 01/04/2007 05:49AM
Re: Two general MySQL questions   1,556 Toa Sty 01/04/2007 10:53AM
i've got the query optimization blues ... stumped   1,851 Joe Simone 12/15/2006 02:48PM
Re: i've got the query optimization blues ... stumped   1,543 Toa Sty 01/04/2007 10:32AM
How to optimize the "order by" & "limit" query?   2,363 Jiangyubao Jiangyubao 12/18/2006 09:48AM
Re: How to optimize the "order by" & "limit" query?   1,660 Toa Sty 01/04/2007 10:25AM
parallelizing queries   1,815 Niklas Saers 01/02/2007 05:59AM
Query with GROUP BY (Using index for group-by -> Using index)   7,763 mnf 11/30/2006 05:20AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,697 mnf 12/06/2006 02:03AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,581 KimSeong Loh 12/07/2006 12:19AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,541 mnf 12/25/2006 06:35AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   3,142 KimSeong Loh 11/30/2006 08:18PM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,917 mnf 12/01/2006 12:21AM
optimization with table_cache   43,877 rei 09/05/2006 09:17PM
Re: optimization with table_cache   18,012 Björn Steinbrink 12/20/2006 02:45AM
Re: optimization with table_cache   18,555 sneakyimp 12/18/2006 10:40PM
Re: optimization with table_cache   18,425 Björn Steinbrink 12/20/2006 02:37AM
Optimizer Tool   2,325 Danie Van der Walt 09/04/2006 03:10AM
Re: Optimizer Tool   1,760 Yogesh Salvi 12/13/2006 04:57AM
Re: Optimizer Tool   2,552 KimSeong Loh 12/13/2006 07:39PM
Creating an index to include ORDER BY   2,092 Angus 11/02/2006 08:28AM
Re: Creating an index to include ORDER BY   1,528 KimSeong Loh 11/02/2006 05:31PM
Re: Creating an index to include ORDER BY   1,604 Angus 11/03/2006 09:24AM
Re: Creating an index to include ORDER BY   1,557 Yogesh Salvi 12/13/2006 05:02AM
Bad performance caused by DISTINCT?   6,846 Heist TheAlmighty 11/13/2006 02:02PM
Re: Bad performance caused by DISTINCT?   2,883 Yogesh Salvi 12/13/2006 04:46AM
Re: Bad performance caused by DISTINCT?   3,640 KimSeong Loh 11/19/2006 09:29PM
Two possible indexes in simple select but none is used   2,343 Ozkan Mehmedali 11/28/2006 10:40AM
Re: Two possible indexes in simple select but none is used   1,483 Yogesh Salvi 12/13/2006 04:41AM
Re: Two possible indexes in simple select but none is used   1,531 KimSeong Loh 11/28/2006 06:27PM
how turn off optimizer?   2,117 krix asdasd 11/28/2006 11:40AM
Re: how turn off optimizer?   1,684 KimSeong Loh 11/28/2006 06:25PM
Re: how turn off optimizer?   1,975 krix asdasd 11/30/2006 02:04AM
Re: how turn off optimizer?   1,705 Dewey Gaedcke 12/12/2006 06:24PM
Re: how turn off optimizer?   1,659 Dewey Gaedcke 11/28/2006 11:24PM
Golden Rules of writting efficient query   4,958 Yogesh Salvi 11/23/2006 01:37AM
Re: Golden Rules of writting efficient query   1,912 Satya Prakash 12/08/2006 08:28AM
Re: Golden Rules of writting efficient query   2,260 KimSeong Loh 11/23/2006 02:17AM
Liberating Dependent Subqueries   10,029 Shlomo Swidler 11/27/2006 05:50PM
A more general way to do it   2,862 Shlomo Swidler 12/05/2006 08:43AM
Improvements to "constify"   2,615 Shlomo Swidler 12/07/2006 06:26AM
Re: Liberating Dependent Subqueries   2,356 mnf 12/01/2006 09:35AM
Re: Liberating Dependent Subqueries   2,100 KimSeong Loh 12/03/2006 06:21PM
Re: Liberating Dependent Subqueries   2,051 mnf 12/03/2006 08:18PM
Re: Liberating Dependent Subqueries   2,101 Shlomo Swidler 12/05/2006 06:11AM
Re: Liberating Dependent Subqueries   2,656 KimSeong Loh 11/28/2006 06:29PM
Re: Liberating Dependent Subqueries   3,224 Shlomo Swidler 11/30/2006 05:39PM
Re: Liberating Dependent Subqueries   2,979 Vikash Bucha 11/28/2006 12:57AM
Re: Liberating Dependent Subqueries   2,658 Shlomo Swidler 11/28/2006 03:09AM
Update with dependent subquery needs optimization!   3,139 Lon B 12/06/2006 05:23PM
Re: Update with dependent subquery needs optimization!   1,676 Björn Steinbrink 12/07/2006 02:04AM
optimizer using sql_no_cache   2,963 alan langridge 12/06/2006 07:56AM
Re: optimizer using sql_no_cache   1,623 alan langridge 12/06/2006 11:07AM
Optimizing a query   1,880 Ryan Smith 11/28/2006 10:37AM
Re: Optimizing a query   1,540 KimSeong Loh 11/28/2006 06:28PM
Join with more strict condition shows the record which is not visible without it   2,136 Michal Jaskolski 11/24/2006 06:08AM
Multiple join and Where clause   34,390 michele terlizzi 11/15/2006 05:13AM
Re: Multiple join and Where clause   5,570 Björn Steinbrink 11/22/2006 04:20PM
Including set type in index   2,991 Angus 11/10/2006 01:56PM
Re: Including set type in index   1,886 KimSeong Loh 11/12/2006 06:55PM
Re: Including set type in index   1,750 Angus 11/13/2006 09:36AM
to save as text block? or to save as rows?   1,986 ryan morris 11/10/2006 06:09PM
ignore   1,895 chris bagnall 11/10/2006 03:44AM
deleting approx. 180m records a month   1,957 Nolan Rumble 11/06/2006 03:09PM
Re: deleting approx. 180m records a month   1,551 KimSeong Loh 11/06/2006 07:04PM
Query cache   1,990 Markus Doppelbauer 10/31/2006 01:32PM
Re: Query cache   1,570 Toa Sty 10/31/2006 04:12PM
Re: Query cache   1,545 Markus Doppelbauer 11/01/2006 06:27AM
Re: Query cache   1,517 Michael Dar 11/01/2006 12:25PM
Re: Query cache   1,547 Toa Sty 11/02/2006 03:11AM
optimizing abs()   2,354 Michiel Betel 10/25/2006 04:31AM
Re: optimizing abs()   1,690 Toa Sty 10/25/2006 05:37AM
Re: optimizing abs()   1,604 Michiel Betel 10/29/2006 07:31AM
Optimizer ignores datetime index   3,773 Angus 10/27/2006 09:51AM
Re: Optimizer ignores datetime index   2,763 Toa Sty 10/27/2006 12:48PM
Re: Optimizer ignores datetime index   2,280 Angus 10/27/2006 01:09PM
Derived tables optimized differently than when directly queried?   2,746 Tom Callahan 10/25/2006 02:38PM
Re: Derived tables optimized differently than when directly queried?   1,568 Björn Steinbrink 10/26/2006 05:33PM
Simple Query - No Join - But Temp. Table and file Sort :(   2,508 Heiko G. 10/21/2006 09:06AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(   1,764 Toa Sty 10/21/2006 10:55AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(   2,090 Heiko G. 10/22/2006 04:56AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(   1,716 Heiko G. 10/21/2006 11:17AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(   2,009 Toa Sty 10/23/2006 06:41AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(   1,766 Heiko G. 10/23/2006 11:02AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(   1,652 Toa Sty 10/23/2006 01:01PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(   1,798 Ravenous Bugblatter Beast 10/21/2006 05:20PM
Optimizer ignores number of records   1,814 Lite Wait 09/15/2006 06:28AM
Re: Optimizer ignores number of records   1,412 Ravenous Bugblatter Beast 10/21/2006 05:05AM
Current Page: 12 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.