How can you rebuild an index?

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

Question Posted / guest

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

what is ora 24313?what is the procedure to exclude that error?

0 Answers

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

Describe what redo logs are.

1 Answers

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers

What are the steps you will take to improve performance of a poor performing query?

0 Answers

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

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

0 Answers

Give two examples of how you might determine the structure of the table DEPT.

2 Answers

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

How can we see the database version in os level

6 Answers Oracle,

For more DB Administration Interview Questions Click Here