… and checking if it matches our original WHERE clause with subselects. It looks scary if we look at EXPLAIN but in… not the most optimal. We do not really need separate subselect to make MySQL check WHERE clause while scanning table in…
Comment: My Innodb Feature wishes
May 14, 2006 By 30 Comments
Gokhan, In this case it could be Optimizer bug with subselect execution or with explain. Please report it at http://bugs… are VERY many missing optimizations with Subselects at this point. You should be very careful migrating Subselects from other Database servers as…
Comment: Air traffic queries in InfiniDB: early alpha
November 3, 2009 By 19 Comments
… this is meaningful information for folks. subselects: Yes, you are correct, we currently do not support subselect. As Robin mentioned in a…
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… Web applications. And the good development would be to have Subselects and prepared statements fixed for next release rather than adding… baked features. The manor features in MySQL 4.1 were Subselects, Prepared Statements and Character Sets. All they were not done…
Comment: Derived Tables and Views Performance
September 1, 2006 By 14 Comments
… based on real production cases. Note: It applies to subselects in FROM clause only. Other kind of subselects is very different story.
Post: Derived Tables and Views Performance
August 31, 2006 By 14 Comments
… for what is called derived tables, inline views or basically subselects in the from clause. In MySQL 5.0 support for… instead of derived tables If you really need to use subselect in from clause consider creating view using it in the…
Comment: My Innodb Feature wishes
May 13, 2006 By 30 Comments
… avaiable as subselect is not executed. Now if you look at the number of rows query would return without subselect: mysql> select…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…_vtable_mode). mysql> show warnings; +——-+——+————————————————————+ | Level | Code | Message | +——-+——+————————————————————+ | Error | 9999 | Subselect in From clause is not supported in this release…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… to be done first. Another reason is “Derived Tables” AKA “Subselects in FROM Clause” are not optimized yet even though some…
Comment: MyISAM Scalability and Innodb, Falcon Benchmarks
October 15, 2007 By 10 Comments
… is the temp table workaround. Might be able to use subselects to avoid the huge data load as well. In my…
