I've always disliked the need to write these sorts of queries because I've never come up with a way that I felt was truly *optimal*.

But in general, this is what...

Index rebuilds are nightly.

There should be very few deletes, possibly more updates than necessary though.