InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Main Advantages And Disadvantages Of Using Identity Columns? |
|
Answer» The main advantage of an identity column is that it can generate unique, SEQUENTIAL numbers very efficiently,REQUIRING only a minimal amount of I/O. The disadvantage is that the generated VALUES themselves are not transactional, and that the identity values may jump ENORMOUSLY when the server is shutdown the rough way (RESULTING in “identity gaps”). The main advantage of an identity column is that it can generate unique, sequential numbers very efficiently,requiring only a minimal amount of I/O. The disadvantage is that the generated values themselves are not transactional, and that the identity values may jump enormously when the server is shutdown the rough way (resulting in “identity gaps”). |
|