Need some information on Index Rebuilding. (sort_in_tempdb = off)
When performing index rebulding (for indexes > 30% fragmented), will we expect to see an increase in the user transaction log size (LDF)? Or we will expect to see an increase in the database size instead (MDF)?
Anyway to calculate how much size needed for rebuilding indexes?
Let's say if i need to rebuild 3 indexes, each about 5 GB.
After rebuilding the first index, will the temporary space used for rebuilding the first index be reuse for the 2nd index? Or we first need to perform a transaction log backup before the space can be reused?