|
|
Posted by Hugo Kornelis on 10/12/57 11:52
On 10 Jul 2006 07:31:10 -0700, rcamarda wrote:
(snip)
>Heres the situation: I find it takes 45 minutes to do a relational
>update, where only the records that changed in the last day will be
>loaded.
Hi Rob,
What column(s) is/are used to relate rows in the staging tables to the
matching rows in the target table? Are there any indexes on the staging
table? Can you post the query you use for this relational update?
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|