Ana C. Dent wrote:
> gautrak_at_yahoo.com (Gautrak) wrote in
> news:76ceef56.0409190825.240ff9a8_at_posting.google.com:
>
>
>>Hi,
>>Oracle version : 9.2
>>
>>A transaction, in addition to other statements, involves first
>>deleting all records belonging to that userid and then insert fresh
>>set from another table.
>>The database must be able to support large number of users, each with
>>own userid, performing this transaction.
>>
>>I believe this is not a good design but have no control on this part.
>>
>>To ensure that these delete statements do not result in any
>>bottlenecks, what should be the focus areas.
>>
>>Thanks and regards,
>>Gautrak
>>
>
>
> Do NOT use DELETE use TRUNCATE instead.
In a multiuser environment you suggest using TRUNCATE? Why?
What result do you expect with two simultaneous transactions?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Sep 19 2004 - 12:23:11 CDT
