Do primary keys change when indexes are rebuilt or reorganized?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty{ margin-bottom:0;
}
up vote
2
down vote
favorite
I have a database containing tables that each have auto-increment int columns serving as the primary key column.
When I do a rebuild or reorganize operation on my indexes, does either operation potentially change the values of this column?
Does it matter if the indexes are 'clustered'?
I'm using various versions of MS T-SQL from 2008 onward.
sql-server index primary-key
asked yesterday
Dragonsdoom
1194
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
2
down vote
favorite
I have a database containing tables that each have auto-increment int columns serving as the primary key column.
When I do a rebuild or reorganize operation on my indexes, does either operation potentially change the values of this column?
Does it matter if the indexes are 'clustered'?
I'm using various versions of MS T-SQL from 2008 onward.
sql-server index primary-key
asked yesterday
Dragonsdoom
1194
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3
Index reorganizations or rebuilds will not alter data, only make sure it is laid out on disk in the proper order. The only thing that can change an auto-increment value (other than an insert/update/delete) is a truncate (resets the increment) or an RESEED command.
– Jonathan Fite
yesterday
3
@JonathanFite perhaps you should add this as an answer rather than a comment?
– George.Palacios
yesterday
@JonathanFite thank you for the information.
– Dragonsdoom
yesterday
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I have a database containing tables that each have auto-increment int columns serving as the primary key column.
When I do a rebuild or reorganize operation on my indexes, does either operation potentially change the values of this column?
Does it matter if the indexes are 'clustered'?
I'm using various versions of MS T-SQL from 2008 onward.
sql-server index primary-key
asked yesterday
Dragonsdoom
1194
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a database containing tables that each have auto-increment int columns serving as the primary key column.
When I do a rebuild or reorganize operation on my indexes, does either operation potentially change the values of this column?
Does it matter if the indexes are 'clustered'?
I'm using various versions of MS T-SQL from 2008 onward.
sql-server index primary-key
sql-server index primary-key
asked yesterday
Dragonsdoom
1194
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Dragonsdoom
1194
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Dragonsdoom
1194
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Dragonsdoom
1194
asked yesterday
Dragonsdoom
1194
1194
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Dragonsdoom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3
Index reorganizations or rebuilds will not alter data, only make sure it is laid out on disk in the proper order. The only thing that can change an auto-increment value (other than an insert/update/delete) is a truncate (resets the increment) or an RESEED command.
– Jonathan Fite
yesterday
3
@JonathanFite perhaps you should add this as an answer rather than a comment?
– George.Palacios
yesterday
@JonathanFite thank you for the information.
– Dragonsdoom
yesterday
add a comment |
3
Index reorganizations or rebuilds will not alter data, only make sure it is laid out on disk in the proper order. The only thing that can change an auto-increment value (other than an insert/update/delete) is a truncate (resets the increment) or an RESEED command.
– Jonathan Fite
yesterday
3
@JonathanFite perhaps you should add this as an answer rather than a comment?
– George.Palacios
yesterday
@JonathanFite thank you for the information.
– Dragonsdoom
yesterday
3
3
Index reorganizations or rebuilds will not alter data, only make sure it is laid out on disk in the proper order. The only thing that can change an auto-increment value (other than an insert/update/delete) is a truncate (resets the increment) or an RESEED command.
– Jonathan Fite
yesterday
Index reorganizations or rebuilds will not alter data, only make sure it is laid out on disk in the proper order. The only thing that can change an auto-increment value (other than an insert/update/delete) is a truncate (resets the increment) or an RESEED command.
– Jonathan Fite
yesterday
3
3
@JonathanFite perhaps you should add this as an answer rather than a comment?
– George.Palacios
yesterday
@JonathanFite perhaps you should add this as an answer rather than a comment?
– George.Palacios
yesterday
@JonathanFite thank you for the information.
– Dragonsdoom
yesterday
@JonathanFite thank you for the information.
– Dragonsdoom
yesterday
add a comment |
1 Answer
1
active
oldest
votes
up vote
9
down vote
accepted
No, they will not.
Rebuilding or reorganizing an index should never alter the underlying data itself, only its placement within database pages / extents.
However, as an aside have a read through this post - you might find that you don't need to rebuild these indexes in the first place.
answered yesterday
George.Palacios
1,777620
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
9
down vote
accepted
No, they will not.
Rebuilding or reorganizing an index should never alter the underlying data itself, only its placement within database pages / extents.
However, as an aside have a read through this post - you might find that you don't need to rebuild these indexes in the first place.
answered yesterday
George.Palacios
1,777620
add a comment |
up vote
9
down vote
accepted
No, they will not.
Rebuilding or reorganizing an index should never alter the underlying data itself, only its placement within database pages / extents.
However, as an aside have a read through this post - you might find that you don't need to rebuild these indexes in the first place.
answered yesterday
George.Palacios
1,777620
add a comment |
up vote
9
down vote
accepted
up vote
9
down vote
accepted
No, they will not.
Rebuilding or reorganizing an index should never alter the underlying data itself, only its placement within database pages / extents.
However, as an aside have a read through this post - you might find that you don't need to rebuild these indexes in the first place.
answered yesterday
George.Palacios
1,777620
No, they will not.
Rebuilding or reorganizing an index should never alter the underlying data itself, only its placement within database pages / extents.
However, as an aside have a read through this post - you might find that you don't need to rebuild these indexes in the first place.
answered yesterday
George.Palacios
1,777620
answered yesterday
George.Palacios
1,777620
answered yesterday
George.Palacios
1,777620
answered yesterday
George.Palacios
1,777620
1,777620
add a comment |
add a comment |
Dragonsdoom is a new contributor. Be nice, and check out our Code of Conduct.
Dragonsdoom is a new contributor. Be nice, and check out our Code of Conduct.
Dragonsdoom is a new contributor. Be nice, and check out our Code of Conduct.
Dragonsdoom is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f224017%2fdo-primary-keys-change-when-indexes-are-rebuilt-or-reorganized%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
Index reorganizations or rebuilds will not alter data, only make sure it is laid out on disk in the proper order. The only thing that can change an auto-increment value (other than an insert/update/delete) is a truncate (resets the increment) or an RESEED command.
– Jonathan Fite
yesterday
3
@JonathanFite perhaps you should add this as an answer rather than a comment?
– George.Palacios
yesterday
@JonathanFite thank you for the information.
– Dragonsdoom
yesterday