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 would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

What is a system database and what is a user database? : sql server DBA

0 Answers  

What is dcl? : sql server DBA

0 Answers  

what is logical system in sap basis

0 Answers  

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

How many packages we have in db

1 Answers   Tesco,

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

how can you initialize log miner?

0 Answers   Oracle,

What is the importance of a recovery model? : sql server DBA

0 Answers  

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,