1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

Question Posted / anjani kumar


You want to be sure that queries in a database always execute at the maximum possible speed. To achi..

Answer / Brahma Swaroop Sharma

To maintain a database in good condition and ensure optimal performance, regular maintenance tasks are crucial. One such task is reorganizing indexes using the DBCC INDEXDEFRAG command or ALTER INDEX REORGANIZE statement. This operation defragments the leaf level pages of the index, making them more compact and reducing fragmentation, thereby improving query performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the different types of joins and what does each do?

2 Answers  

Why Master database is required?

1 Answers   Abacus,

Explain the storage models of OLAP?

1 Answers  

What are different replication agents and what's their purpose? : sql server replication

1 Answers  

Write the SQL query to drop, truncate and delete table.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

How to add additional conditions in SQL?

1 Answers   Amdocs,

How to maintain a fill factor in existing indexes?

1 Answers  

When would you prefer to have a minimum number of indexes?

1 Answers  

What is the difference between set and select?

1 Answers  

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1 Answers  

Can binary strings be used in arithmetical operations?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories