|Subject||Re: [firebird-support] Adding index befor or after filling table?|
> Den 2011-08-10 12:52 skrev Thomas Steinmaurer såhär:You can't deactivate the underlaying index of a primary key constraint.
>> > We're going to publish data from a large database into a smaller one.
>> > Primary keys and othe rindexed values will probably be inserted in
>> > random order.
>> > Is it more efficient to add indexes/pk:s after the insert than before?
> Thanks. To separate DDL and DML in my code I'd still like to create
> indexes where I create the tables. So, excepting PK:s, I may want to
> just deactivate indexes while pumping the data and the reactivate them.
> Will this have performance as if I deferred index creation to afterActivating an index rebuilds the index.
> pumping the data?
> I think I can live with the performance hit of having the PK indexIt would be good if you re-calculate the selectivity after the import
> active during data pump. The PK:s are bigints. Is this a bad idea? I
> think there will be 5-10 million inserts in total across all tables, the
> largest three tables containing about 1 million records each.
for those indices, which have been active during the import. I have a
stored procedure in all my databases which execute a SET STATISTIC on
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server