|
Posted by Magnus Φsterberg on 10/01/08 11:19
Hi!
I'm experiencing the following experience problem with my SQL Server 2000.
Explanation a' la example;
1.
I insert data using my SP; EXEC dbo.up_DataInsert
This is fine, SQL Profiler duration only a few ms.
2.
I try to select the data.
select * from dbo.tblData where DataNumber = 283279
This is fine, SQL Profiler duration only a few ms.
3.
delete from dbo.tblData where DataNumber = 283279
This is NOT fine, SQL Profiler duration up to 50 seconds!!!
I have got a unique index with ignore duplicate key and the table has about
180.000 records.
What could be wrong here??
/Magnus
Navigation:
[Reply to this message]
|