Brown, Charles wrote:
> Hello Dan. Try it and see if you can:
>
> mysql> create index indx101 on tab101(min(c1),c2) ;
>
> Answer: Its not supported.
>
>
> -----Original Message-----
> From: Dan Nelson [mailto:dnelson@stripped]
> Sent: Tuesday, March 13, 2007 9:10 AM
> To: Ananda Kumar
> Cc: mysql@stripped
> Subject: Re: function based index
>
> 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.
Hi! We've recently opened up our public worklog for commenting... which
means you should definitely add comments to the worklog task which
covers function indexes:
http://forge.mysql.com/worklog/task.php?id=1075
Cheers!
jay
