MySQL Forums
Forum List  »  Falcon

Falcon can not use index for sorting?
Posted by: Yuan WANG
Date: May 13, 2007 07:57AM

The following simple test shows that Falcon can not use index for sorting. This is a very serious problem. However, I searched around the world and found no discussions about it. So, is this a minor problem caused by a temporary mistake or a design issue?

Falcon version: 6.0.1 alpha

mysql> create table t(a int primary key, b int, c int) engine = falcon;
mysql> create index idx_t_ab on t(a, b);
mysql> insert into t values(1,1,1);
mysql> explain select * from t force index (idx_t_ab) where a = 1 order by b limit 10;
+----+-------------+-------+------+---------------+----------+---------+-------+------+-----------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+----------+---------+-------+------+-----------------------------+
| 1 | SIMPLE | t | ref | idx_t_ab | idx_t_ab | 4 | const | 10 | Using where; Using filesort |
+----+-------------+-------+------+---------------+----------+---------+-------+------+-----------------------------+

Options: ReplyQuote


Subject
Written By
Posted
Falcon can not use index for sorting?
May 13, 2007 07:57AM


Sorry, you can't reply to this topic. It has been closed.

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.