Advertisement
Guest User

GUID vs INT clustered PK's (GUID wins again)

a guest
May 21st, 2013
222
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.74 KB | None | 0 0
  1. BEGIN TRANSACTION
  2.  
  3. CREATE TABLE Table1(
  4.         [Guid] [uniqueidentifier] PRIMARY KEY WITH (FILLFACTOR = 90),
  5.         TestID INT IDENTITY(1,1),
  6.         UNIQUE NONCLUSTERED (TestID)
  7. )
  8.  
  9. DECLARE @i INT
  10. SET @i = 1
  11. WHILE @i < 1000000
  12. BEGIN
  13.         INSERT INTO Table1 (Guid) VALUES (newid())
  14.         SET @i = @i + 1
  15. END
  16. ROLLBACK TRANSACTION
  17.  
  18. -- 23 seconds
  19.  
  20. BEGIN TRANSACTION
  21.  
  22. CREATE TABLE Table2(
  23.         [ID] [INT] PRIMARY KEY IDENTITY(1,1),
  24.         [Guid] [uniqueidentifier] NOT NULL,
  25.         UNIQUE NONCLUSTERED ([Guid] ASC) WITH (FILLFACTOR = 90)
  26. )
  27.  
  28. DECLARE @i INT
  29. SET @i = 1
  30. WHILE @i < 1000000
  31. BEGIN
  32.         INSERT INTO Table2 (Guid) VALUES (newid())
  33.         SET @i = @i + 1
  34. END
  35. ROLLBACK TRANSACTION
  36.  
  37. -- 26 seconds
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement