CODEWITHSUNDEEP
sql-serverdatabaseindexing
seeker
seeker

Reputation: 3333

Adding indexes to existing database

I have database with tables full of data. I would like to add indexes ( both clustered and non-clustered). Is it possible to add indexes without having to insert this data again ( I mean create new DB with indexes and export data from the old one to new one)? As I know clustered indexes are saved physically which means I won't be able to do that without recreating DB. But still, is it possible to add indexes to existing database?

Upvotes: 0

Views: 770

Answers (1)

Oded
Oded

Reputation: 499312

Is it possible to add indexes without having to insert this data again?

Yes. Not only is it possible, it makes little sense to remove the data before adding the indexes.

Adding an index to a large table may take a long time though.

Upvotes: 3

Related Questions