Posted by gobwash@gmail.com on 11/29/06 21:18

Do aggregate functions (sum, count, min, max) inherently cause table
locks?

More concretely, would the following query typically result in a table
lock?

select sum(quantity) as total
from products

Thanks,
Scott

• Next in forum: MI5 Persecution: Home Office MI5 Liaison won't comment
• Prev in forum: MI5 Persecution: A letter from MI5
• Thread view: Aggregate functions and locking

[Reply to this message]