Why sequence provides better performance as opposed to Identity Columns?

Posted by Rajnilari2015 on 2/17/2016 | Category: Sql Server Interview questions | Views: 1589 | 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

Bookmark It

< Previous : Identify the true statements

Next > : Which of the following are true?

More Interview Questions by Rajnilari2015

Latest Interview Questions