• Hi Matt, thanks for the prompt response!

    As I'm looking at my environment at large, I'm finding multiple incidents where I've been doubling down on the work to do because of this logic.

    This particular index, it's a clustered index, on one nvarchar(32) column. So this one in particular, how/why does it have a LOB_DATA?

    Either way, I'm veering off topic vs. the overall inquiry of attempting to understand how to focus a reindex routine. Is there a general rule/reasoning to what to focus on and why? Based on most existing routines out there that I've reviewed, most are simply using a where clause for in_row_data.