Answer Posted / ramesh
ALTER INDEX <Index> REBUILD ONLINE;
one Should Configure a script to Rebuild indexes at Regular
intervals for the needy
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What are the different ways you can create databases in sql server? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How to start SQL Server in minimal configuration mode?
What the different topologies in which replication can be configured? : sql server DBA
how does an oracle clusterware manage crs resources?
when does an alert gets signaled?
What is the importance of a recovery model? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you process messages in order asynchronously?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what is the use of recording information about current session?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?