MySQL Forums
Forum List  »  Optimizer & Parser

Re: Functions in the where clause
Posted by: Timour Katchaounov
Date: May 22, 2007 04:50AM

Yes, functions in the WHERE clause are just like any other expression -
they are evaluated for every row IF the function depends on table data.
However, if a function depends only on constants it will be evaluated
once.

--
Timour Katchaounov, Software Engineer - Optimizer
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
4129
May 21, 2007 10:26AM
Re: Functions in the where clause
2462
May 22, 2007 04:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.