• Thanks very much for the replies, at the very least the usage of the column is clear.

    Seems to be it would be more useful if the user_lookup values were populated in each instance of the NC indexes instead so that you could identify the offending ones rather than just have them lumped in the clustered/heap.

    I'm going to look back over the script tonight ( ), it is kinda long and there's probably something I'm missing in it.