01.07.2015 13:34, Jiří Činčura wrote: >> If new datatype is the same from index POV, there is no need to rebuild >> index. > > Not sure what you mean by same? Let's say I change it from smallint to int.
All kind of numbers have the same representation in index keys. So, in the case above there is no need to rebuild index. >> Else, IIRC, engine rebuild all indices dependent on domain-based fields. >> You can check it yourself, btw :) > > How? Look at execution statistics. If commit took more time than expected (few ms), performs a lot of fetches\marks, etc - it could be sign that index(es) was rebuild. Regards, Vlad ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
