Difference between index rebuid and desstroy and create index

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

there are is type of index adjustment rebuild and reorganize.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

river1 (5/25/2011)
Hi,
Is there any difference between reindex an index and destroy the index and then create it again?

The rebuild will do the same (destroy the index and then create it again)

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 3

That's what it's basically doing, but it's doing it in a single command as opposed to two. Why do you ask?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

george sibbald SSC Guru Points: 104210 More actions · Answer 4

do you mean drop the index and then recreate or using create index with drop_existing?

using alter index means indexes enforcing PRIMARY KEY and UNIQUE constraints can be rebuilt without dropping and re-creating the constraints.

alter index is atomic.

alter index with the all clause would do all the indexes on a table in one command.

There are a number of differences - Best refer to BOL.

---------------------------------------------------------------------