Skip to Content

Anyway to drop an individual cached statement in ASE 16+

I thought I remember seeing a command to drop an individual cached statement (or was it a query plan?). I know there's a command to flush the whole statement cache. That's a separate thing.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 01, 2017 at 07:16 PM

    Not sure about 16+ specific commands, but since 15.5 there's dbcc purgesqlcache(sqlid)

    And a (very) brief tidbit in the ASE WIKI : dbcc purgesqlcache

    Add comment
    10|10000 characters needed characters exceeded