Why sequence provides better performance as opposed to Identity Columns?

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

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