1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How can you rebuild an index?

Question Posted / guest

Answers were Sorted based on User's Feedback



How can you rebuild an index?..

Answer / ramesh

ALTER INDEX <Index> REBUILD ONLINE;

one Should Configure a script to Rebuild indexes at Regular
intervals for the needy

Is This Answer Correct ?    10 Yes 2 No

How can you rebuild an index?..

Answer / ehtesham malik

Alter index index_name REBUILD COPMUTE STATISTICS

Is This Answer Correct ?    6 Yes 2 No

How can you rebuild an index?..

Answer / deepak

alter index <indexname> rebulid;

Is This Answer Correct ?    5 Yes 2 No

How can you rebuild an index?..

Answer / ravikiran koppisetty

ALTER INDEX INDEXNAME REBUILD

Is This Answer Correct ?    3 Yes 1 No

How can you rebuild an index?..

Answer / guest

dbcc dbreindex ('table_name' [, index_name [,
fillfactor ]]) [WITH NO_INFOMSGS]

Is This Answer Correct ?    2 Yes 2 No

How can you rebuild an index?..

Answer / kishore

DBCC dbreindex('tabname','indexname','fillfactor')

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB Administration Interview Questions

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

what is grd?

0 Answers   Oracle,




Why would you use sql agent? : sql server DBA

0 Answers  

What view would you use to look at the size of a data file?

3 Answers  

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

How can you gather statistics on a table?

3 Answers  

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

Why would you call update statistics? : sql server DBA

0 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

For more DB Administration Interview Questions Click Here
Categories