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:
Post a Comment