Pages

Search This Blog

Thursday, August 5, 2010

[T-SQL] GUID vs INT

INT
Advantage:

1.Numeric values (and specifically integers) are better for performance when used in joins, indexes and conditions.
2.Numeric values are easier to understand for application users if they are displayed.
Disadvantage:

1.If your table is large, it is quite possible it will run out of it and after some numeric value there will be no additional identity to use.
GUID
Advantage:

1.Unique across the server.
Disadvantage:

1.String values are not as optimal as integer values for performance when used in joins, indexes and conditions.
2.More storage space is required than INT

No comments: