>Does anyone know how to delete all the records from a remote view. I have a table with 4500 records. I used DELETE ALL from a remote view of that table (I must use a remote view) but it takes like five minutes to perform that operation. I need a faster way to do this but I can't use the table directly.
>Thank you.
How do you have the table buffered? Are you using ROW or TABLE buffering? If you are using ROW buffering, try table buffering the sucker and then doing the tableupdate.
HTH