How can you rebuild an index?

Answer Posted / kishore

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

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1855


What is transparent data encryption? : sql server DBA

572


what is the use of recording information about current session?

576


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

2057


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1734






What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

622


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

591


how can you connect from 10g user to 11g user??

1689


What are statistics, under what circumstances they go out of date, how do you update them?

1818


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

566


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

668


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

1913


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

549


how can you find out if a table can be redefined?

601


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3323