sql server programming: Design for performance --please suggest -- sql server programming

Design for performance --please suggest

loufuki NO[at]SPAM gmail.com
10/17/2007 10:27:24 PM

sql server programming: Hi

I have a table T1 that needed to go into server DW (DataWarehouse).
However, It will be used in server Staging for other pursposes and
will be deleted after that..

I have a two options to do this but don't know exactly which one is
better.
1. Only copy to DW and use it in Staging
2 Copy to both DW and Staging and delete it in Staging after using it

What are the advantages and disadvantage of both methods?
Which one should I use ?

Thanks

Re: Design for performance --please suggest

David Portas
10/18/2007 7:10:32 AM

[quoted text, click to view]

Depends on what other activity is happening in each case. If creating a copy
helps reduce contention for resources then do it, but I have no way of
knowing which will perform better.

--
David Portas