From: Dmitry Y. <fir...@ya...> - 2012-11-09 17:20:56
|
09.11.2012 18:20, Poul Dige wrote: > > 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. > 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. Dmitry |