How can you rebuild an index?

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

Question Posted / guest

6 Answers
14100 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

How would you go about generating an EXPLAIN plan?

2 Answers

Explain the use of table functions.

1 Answers

what is the role of dip user in our database?

0 Answers

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

3 Answers

any body know about orawaves do they really provide placements in their unique placement program

1 Answers TCS,

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

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

2 Answers Mphasis,

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

what is the use of recording information about current session?

0 Answers Oracle,

how can you find out if a table can be redefined?

0 Answers Oracle,

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers

what do you understand by flashback feature of oracle?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here