List:General Discussion« Previous MessageNext Message »
From:Charles Brown Date:March 13 2007 7:26pm
Subject:RE: function based index
View as plain text  
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. 

-- 
	Dan Nelson
	dnelson@stripped

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************
Thread
function based indexAnanda Kumar13 Mar
  • Re: function based indexDan Nelson13 Mar
    • RE: function based indexCharles Brown13 Mar
      • Re: function based indexJay Pipes13 Mar