After you create an index for a table, should we see performance improve immediately? Does the application using it need to re-connect or should it just stay running as normal?

  • I have retagged your question from [sql] and [server] to [sql-server]. If this is incorrect, please edit again to specify the product you are using. – Paul White Dec 1 '16 at 6:21

After an index is created on a table, it can be used immediately by queries. But that doesn't mean the index is going to be used or that the index is going to improve performance immediately. Validate that the index is being used by the query(ies) you were targeting and compare performance differences.

The first time the index is used, the database may have to read the index pages from disk into memory, so it might take a little longer than on subsequent runs when the index may already be in memory.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.