Why sequence provides better performance as opposed to Identity Columns?

 Posted by Rajnilari2015 on 2/17/2016 | Category: Sql Server Interview questions | Views: 1447 | Points: 40

Sequence gives better performance as compared to Identity Column since it reads from memory rather than from the disk and caches that.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response