Answer / ramesh

ALTER INDEX <Index> REBUILD ONLINE;

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

Answer / ehtesham malik

Alter index index_name REBUILD COPMUTE STATISTICS

Answer / deepak

alter index <indexname> rebulid;

Answer / ravikiran koppisetty

ALTER INDEX INDEXNAME REBUILD

Answer / guest

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

Answer / kishore

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

what is meant by gateway

1 Answers   IBM,

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

when does an alert gets signaled?

0 Answers   Oracle,

what is a crs resource?

0 Answers   Oracle,

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

Datapump backup steps?

1 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

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

2 Answers  

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

How do you open a cluster administrator? : sql server DBA

0 Answers  

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers