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
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:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 9:10 AM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: function
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