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

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

Question Posted / meraj ahmed


You have a table with close to 100 million records recently, a huge amount of this data was updated ..

Answer / Sandip Kumar

To quickly remedy the situation, you can rebuild or reorganize the indexes on the table. Rebuilding an index drops and recreates it, while reorganizing the index does not drop it but reorders the data pages and defragments the index. Another option is to create filtered indexes or columnstore indexes if they are applicable.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

What have included columns when we talk about sql server indexing?

1 Answers  

Define tempdb database?

1 Answers  

What is the sql server 2000 version number?

1 Answers  

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

Explain error handling in ssis?

1 Answers  

How to download microsoft sql server 2005 express edition?

1 Answers  

What are partitioned views and distributed partitioned views?

1 Answers  

What are different types of constraints?

0 Answers  

can you any body tell me the how to decrease the logfile

4 Answers  

How to replace given values with null using nullif()?

1 Answers  

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories