Difference between primary key search and fields search SQL
primary-key, sql
Solution
A key is a logical feature of the database whereas performance is determined entirely by physical features: storage format, indexing and the methods used internally for data access. In principle therefore the answer is No. There is no fundamental reason why there needs to be a difference between accessing data by key or by any other non-key attribute(s). A more specific answer might be possible only if we knew more information about storage, indexing and what DBMS you are using.
Problem
Is there any difference with performance when we are searching / selecting the records with the primary key and the other fields of same sizes? Also the comparison in performances of such queries with GUID as primary keys and Int as primary keys will be different?