Hi, Needed information regarding record locking in case of udf’s with respect to following two cases-
- Since stream udf’s are read only, do they perform record locking?
- Record udf’s can write/update. Do they hold locks for the duration of the udf execution? How does this affect concurrent invocations of the same record udf ? Are they executed serially so as to achieve mutual exclusion? Locking in general will affect consistency/performance as well. Need precise behavior information so as to design queries effectively.