| Subject | Create index while database is in use? |
|---|---|
| Author | Raith,Daniel |
| Post date | 2013-03-01T21:39:35Z |
Is it safe?
I want to create an index on a table but the database (fb1.5) has ~20 active users. Database usage is mostly reads, especially the table I want to index.
I just don't want to take a chance creating an index with active connections could corrupt the database.
Daniel
I want to create an index on a table but the database (fb1.5) has ~20 active users. Database usage is mostly reads, especially the table I want to index.
I just don't want to take a chance creating an index with active connections could corrupt the database.
Daniel