List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 13 2007 2:10pm
Subject:Re: function based index
View as plain text  
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
	dnelson@stripped
Thread
function based indexAnanda Kumar13 Mar
  • Re: function based indexDan Nelson13 Mar
    • RE: function based indexCharles Brown13 Mar
      • Re: function based indexJay Pipes13 Mar