I have a disk based table in solidDB and I wish to create an index:
CREATE INDEX DBINST1.ATH.LOGGING_HISTORY_IX1
This is going into our production server, so to take onlines down and reroute traffic will take a lot of work. Can I simply run the create index, following by a commit to build it? I'm assuming solidDB will need to take an exclusive lock on the table. For this table, users will be updating, deleting and selecting.
We are not using HSB.
Pinned topic Can an index be created without taking an outage?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-19T08:44:14Z at 2012-09-19T08:44:14Z by JarmoRuuth
JarmoRuuth 270005PEEU20 Posts
Re: Can an index be created without taking an outage?2012-09-19T08:44:14ZThis is the accepted answer. This is the accepted answer.Hi Tom,
Yes, you can just create the index. Users trying to write into that table will be blocked but you can still create the index.