what is performance rate on int data type vs uniqueidentifier on sql select?
i read some useful information about uniqueidentifier data type
Primary Key versus Unique Constraint?
PRIMARY KEYs vs. UNIQUE Constraints
http://sqlfool.com/2009/06/primary-key-vs-unique-constraint/
EF 4.0 Guid or Int as A primary Key
GUID Performance
i use two data types "int" and "uniqueidentifier" on my table's columns .
these columns are not identity. i use
select * from mytable where column1=1
select * from mytable where column2=//my GUID
these are two data type and i want to know: using "where" on unique
identifier data type has more deference performance versus use "where" on
int data type or not?
No comments:
Post a Comment