using primary key on tables

#1

Hello there

I had database with table that haven't any index, and primary key.

After that i created new field ID Identity(1,1) primary key clustered. and
the performance improved in good way when i import data to the table using
dts.

can someone explain me whay in this case the performance increased?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

using primary key on tables

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

using primary key on tables - 05-08-2006 , 04:29 AM