yuvipoy (3/4/2014)

---

I am having 10 Master table with 10 million records each.

For unique(primary key) i have use uniqueidentifier as column data type.

While inserting more records on this table insert is slow.

Is this because of uniqueidentifier column?

if so then what can be the alternative.

My table consists of 5 float 10 varchar,3 bit, 8 int,2 uniqueidentifier,4 char, 1 bigint.

uniqueidentifier column is fk for other tables , while joining the columns have used uniqueidentifier column as a primary key.

say

TableA C1 uniqueidentifier (PK), C2 uniqueidentifier, C3 ......

TableB C1 uniqueidentifier , C2 uniqueidentifier (FK_TableA_uniqueidentifier ), C3 ......