naga.rohitkumar (9/22/2014)
suppose if we need to Rebuld or Reorg index how will we come to know which one to select and at which sitiuation can you please ellobarate
As with the other question you asked on the other post about indexes and because these are starting to sound a whole lot like interview questions or "university" questions, you really need to buckle down and spend some time in "Books Online" so that you truly understand the answers to your questions.
For this one, look up "Alter Index" and then do a search for "REBUILD". Also take a look at the script in the examples, study it, and learn from it.
--Jeff Moden
Change is inevitable... Change for the better is not.