P purceld2 Registered User. Local time Today, 09:22 Joined Dec 4, 2008 Messages 79 Dec 10, 2008 #1 Is it better to run a Make-Table Query against some linked Oracle tables or a delete row query and then a append query. Which will be more efficient? I anticipate the process will be required to be run weekly
Is it better to run a Make-Table Query against some linked Oracle tables or a delete row query and then a append query. Which will be more efficient? I anticipate the process will be required to be run weekly
pbaldy Wino Moderator Staff member Local time Today, 01:22 Joined Aug 30, 2003 Messages 36,157 Dec 10, 2008 #2 I would do the second, as I mentioned yesterday. It is more efficient to delete/add records than objects.
I would do the second, as I mentioned yesterday. It is more efficient to delete/add records than objects.
P purceld2 Registered User. Local time Today, 09:22 Joined Dec 4, 2008 Messages 79 Dec 10, 2008 #3 It appears that the table in question is does not allow update/append how can I change this?
