Looking at bug CORE-5774 i found very odd behavior of engine: it seems it rebuilds indices in many unneeded cases, when almost any property of the indexed field is changed.
I understand that index should be rebuild in this cases only: - field data type is changed *and* its "index" type changed too - default value is set at nullable field *and* there was no default value before - "computed by" expression is changed and indices should not be rebuild when: - field data type is changed but its "index" type is still the same - default value is changed (not added) - default value is added or changed at non-nullable field - default value is dropped - field's identity value is restarted - field name is changed - field position is changed Am i missing something ? Am i wrong ? Thanks, Vlad ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel