Answer Posted / sambashiva
This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is report snapshot?
What does indexation mean?
What is sql injection and why is it a problem? : sql server security
Can primary key be null?
What are the two authentication modes in sql server?
What is user defined datatypes and when you should go for them?
What are the aggregate and scalar functions?
What is difference between rownum and row_number?
What is an inner join?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
what is memory-optimized nonclustered indexes
What do you mean by sql server 2005 express management tools?
Which is faster statement or preparedstatement?
What is the difference between having clause and where clause in sql server?
How to view existing indexes on an given table using sp_help?