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

what is a crs resource?

599


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.

1502


How would you go about verifying the network name that the local_listener is currently using?

2757


Explain materialized views and how they are used.

1894


What the different components in replication and what is their use? : sql server DBA

536






what are the types of connection load-balancing?

564


how can you implement fine-grained auditing?

605


What is fill factor? : sql server DBA

644


What would you do with an "in-doubt" distributed transaction?

1418


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1491


what are the differences of where and if in SAS?

1664


what is the role of dip user in our database?

2049


how can a session indicate its interest in receiving alerts?

563


How would you extract DDL of a table without using a GUI tool?

2048


What is transparent data encryption? : sql server DBA

562