Re: multi-process INSERT

Francois Berger wrote:

> Hi,
> I have several process which do INSERT into the same table (no index, no
> constraints). I was wondering if insert statements were treated "at the
> same time" or if there were some kind of lock of the table...
> If there are locks on the table, is it possible to modify it
> in such a way my statements are executed at the same time ?
> Hope anybody can help.
>
> Francois

There are no table locks associated with inserts.

What you mean by "at the same time" eludes me. Ten insert statements are just that ... ten separate insert statements.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)