Hi All experts,

One last question.

Let's say there is a need to rebuild 50+ indexes (due to fragmentation).

I did a check on the DB and the sum of all the indexes to be rebuild is 150GB.

The largest index is about 20 GB size.

Let's say my db recovery model is full and i doesn't do any transaction log backup during that time.

Understand that the target database need free space of the largest size index for rebuild.

But Does it really need 150 GB of transaction log size to do the rebuild?

thanks