|
| Doubt in sql server |
 |
Tue, 1 Apr 2008 00:33:21 -0700 |
which statement will take more processing time in SQL Server?
(A) Insert
|
| Post Reply
|
| Re: Doubt in sql server |
 |
Tue, 1 Apr 2008 06:21:10 -0700 |
On Apr 1, 3:33 am, Santhalakshm...@gmail.com wrote:
> which statement will take more processing time in SQL Server?
> (A) Insert
> (b) Update
The usual way to answer performance questions is to test it.
|
| Post Reply
|
| Re: Doubt in sql server |
 |
Tue, 01 Apr 2008 18:18:05 -070 |
Santhalakshmi.k@gmail.com wrote:
>which statement will take more processing time in SQL Server?
>(A) Insert
>(b) Update
Ed's answer is good, but try drop table. It will make the
subsequent insert and update statements for that table run much
faster.
Yes, I think you should do your own homework, too.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|