|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: function based index
From: Dan Nelson (dnelson
allantgroup.com)
Date: Tue Mar 13 2007 - 09:10:22 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
In the last episode (Mar 13), Ananda Kumar said:
> Is it possible to create function based index in mysql as available
> in oracle. Please point me to any documentation on this.
Sorry; mysql doesn't have function-based indexes. The closest you can
get in mysql is if you add another column and an UPDATE trigger that
populates it with the results of your function, then index that column.
--
Dan Nelson
dnelsonallantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]