Re: Functions in the where clause
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
Subject
Views
Written By
Posted
4183
May 21, 2007 10:26AM
Re: Functions in the where clause
2490
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.