[firebird-support] Create index while database is in use?

[Raith,Daniel]

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

Re: [firebird-support] Create index while database is in use?

[Alexandre Benson Smith]

Em 1/3/2013 18:39, Raith,Daniel escreveu:
 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


If it's not safe, it would not be allowed.

see you !

[firebird-support] Create index while database is in use

[daniel raith]

Is it safe?

I want to create an index on a table with ~20 users on it.  Mostly reads,
especially the table I want to index.

I just don't want to take any chance it could corrupt the database.

Daniel


[Non-text portions of this message have been removed]

Re: [firebird-support] Create index while database is in use?

[Dmitry Kuzmenko]

Hello, Raith,Daniel!

Saturday, March 2, 2013, 1:39:35 AM, you wrote:

RD Is it safe? 

RD I want to create an index on a table but the database (fb1.5) has
RD ~20 active users.  Database usage is mostly reads, especially the table I 
want to
RD index.  

RD I just don't want to take a chance creating an index with active
RD connections could corrupt the database.

With FB 1.5 - yes, if table is being modified when you create
index on it, you may get an index that will have less keys
than values (or versions) in the table.
So, in terms of integrity index will not cover all records,
and can be considered as corrupted, because search of an index
may not include some records. But, you will not get
DB corrupted in terms of corrupted DB. I mean, there will no be
broken structures or data in DB, that can give errors like
consistency check.

Firebird 2.5 have protection for that, i.e. table modifying will be
locked for the time of index creation (if I remember correctly what is
locked - index creation or table data modification).

-- 
Dmitry Kuzmenko, www.ib-aid.com