• In general it will be a bit faster because a guid is 16 bytes where a bigint is only 8 bytes. It is not likely to make a huge difference.

    You mean to say that guid with non cluster index and bigint with cluster index we behave in similar manner.

    how about if there is huge volume of data say about 10 million records will the query fetching time will be same