How do "locks" work when doing deletes?

Posted in 1996

Dave K. Lahoti — Fri, 14 Jun 1996 14:56:05 -0700 — source: Informix-list mailing list archive (1991-1998)

Hi all, Looking for a few simple answer here (at least I believe they are). If I have a table having say a million rows called "ttable", and 2 users simultaneousIy execute a "delete from ttable;" command, will there be any table locks involved. . . a) . . .if the database has logging? b) . . .if the database does not have logging? c) . . .or how about if I have only 1 user performing the command? Would that make a difference with respect to a) & b)? TIA -- +----------------+ | Dave K. Lahoti | == D4kLaho@PacBell.COM --- http://www.PacBell.COM +----------------+