Answer Posted / guest
dbcc dbreindex ('table_name' [, index_name [,
fillfactor ]]) [WITH NO_INFOMSGS]
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Why would you call update statistics? : sql server DBA
what is the use of recording information about current session?
how can a session indicate its interest in receiving alerts?
Query processing is slow(eg select query)how will u solve that
how can you find out if a table can be redefined?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How can you control the amount of free space in your index pages? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you implement fine-grained auditing?
What the different components in replication and what is their use? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is grd?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.