• Yeah, this is pure param sniffing. You're caching and recompiling when you do the reindex.

    There are ways to even out the perf. Just lookup parameter sniffing online and you'll find plenty of resources.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE: