How can you rebuild an index?

Answer Posted / deepak

alter index <indexname> rebulid;

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1977


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1748


how can you enable flashback feature?

532


What is fill factor? : sql server DBA

642


what is a user-defined lock?

584






What are the commands you'd issue to show the explain plan for "select * from dual"?

1723


Why does Oracle not permit the use of PCTUSED with indexes?

2323


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

553


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1585


how can you process messages in order asynchronously?

554


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

575


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1635


what is the use of recording information about current session?

564


What are the different types of indexes available in sql server? : sql server DBA

573


which background process invoke at the time of upgradation tell me???

2223