Hi Dimitry, > > 1. Will it be enough to rebuild indexes, or will it be necessary with a > > complete backup/restore cycle? > > Time to look at the release notes, heh? ;-) Rebuild is enough.
The release note "strongly advises" backup/restore, but in case that is impossible then at least a rebuild. So it just made me wonder if a rebuild will do or if it is only one half of a solution :) > > 2. In case rebuild of indexes is enough, will it be necessary to rebuild > > indexes for transaction time temp tables? > > Such indices are physically alive only as long as your transaction is active, > so > they're out of question. And it's impossible to rebuild them anyway, as > rebuild happens at the commit time when both data and indices have already > disappeared. Doh! I'm a complete moran!:) > > Dmitry > Best regards & thanks for the clarification Poul ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
