Bug #14818 add support for index on function or index on virtual columns
Submitted: 10 Nov 2005 10:19 Modified: 25 Nov 2008 13:16
Reporter: Gunnar von Boehn Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:na OS:Any (na)
Assigned to: CPU Architecture:Any

[10 Nov 2005 10:19] Gunnar von Boehn 
Description:
Could you please consider to add support for  index on function
or index on virtual columns in the near future?
Example: INDEX(soundex(some_column))

This feature will help to noticeable reduce storage requirements in some cases.
Several customers have asked for it in the recent years.
Its well suppored by other DBMS like Oracle and Postgres.

Many thanks in advance

How to repeat:
na

Suggested fix:
na
[27 Feb 2006 5:59] Mike Donnelly 
I'd like to place my vote for this feature too.  I need fast SOUNDEX searching for person first and last names in large databases but can't easily add extra columns.  An "indexed-function" (Oracle) or "index on expression" (Postgres) would be ideal.
[5 Dec 2007 15:26] lepicier thierry 
Very interested in adding support for index on function too.

Thanks
[25 Nov 2008 12:09] [ name withheld ] 
Please rise priority of this feature request.
Feature is supported in Firebird and PostgreSQL
[25 Nov 2008 13:16] Valeriy Kravchuk 
This is a duplciate of bug #4990.