Forum Post: Re: (un)expected Behaviour "for Each"

  • Thread starter Thread starter James Palmer
  • Start date Start date
Status
Not open for further replies.
J

James Palmer

Guest
Just a point of note on your query: any FOR EACH with a function in the left of the predicate will always do a whole index read. In your case above that's not an issue, but as soon as you hit a table with any significant volume of data you will have major performance hits.

Continue reading...
 
Status
Not open for further replies.
Back
Top