How can you rebuild an index?

Answer Posted / ravikiran koppisetty

ALTER INDEX INDEXNAME REBUILD

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1532


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1956


What is the default port no on which sql server listens? : sql server DBA

568


how can you process messages in order asynchronously?

562


What the different types of replication and why are they used? : sql server DBA

579






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

1981


What are the recovery models for a database? : sql server DBA

601


how can you record information about current session?

503


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1913


Explain materialized views and how they are used.

1904


what do you understand by flashback feature of oracle?

568


What is the default fill factor value? : sql server DBA

579


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2201


how can you implement fine-grained auditing?

612


what are the benefits of flashback feature?

599