>Hi,
>I have a view with table buffering, that work fine on retrieve data from tables. However, When I try to add records to it.. and delete records.. it take long time for deletion. It take about 10secs to delete 2000 records (not issue TABLEUPDATE yet). Any ideas to optimize?
>
>I tried to create indexes for the view, but it seem doesn't help on deletion. Pls advise!
>
>Thank you
How is your primary key defined? What indices do you have?
OTOH, 10 seconds doesn't seem like a very long time for 2000 records.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)