• Hi, just curious, how big is this table?

    If the table is very small, table scan is sometimes faster than seek...so, that's why the fragmentation is getting high again.

    Experts, correct me if I'm wrong.

    Regards,
    SQLisAwe5oMe.