How can you rebuild an index?

Categories >> Software >> Databases >> DB Administration
Suggest New Category

Question Posted / guest

6 Answers
13906 Views
I also Faced
E-Mail Answers

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

when does an alert gets signaled?

0 Answers Oracle,

wat is global index and local indes

1 Answers Oracle,

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers Oracle,

Give two methods you could use to determine what DDL changes have been made.

2 Answers

orra 1555 what is this error,why it is occur?

2 Answers Mphasis,

What are the commands used in dcl? : sql server DBA

0 Answers

What purpose does the model database server? : sql server DBA

0 Answers

What command would you use to create a backup control file?

2 Answers

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers Zenith,

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers iGate,

For more DB Administration Interview Questions Click Here