
Turning off cache for a single sql-query
Quote:
> > I am not aware of such command to flush the db cache. It would be
nice to
> > have one though.
> There's a common trick to flush one table's data
> out of cache: bind the table and its indices to
> a different cache. As a minimum, this requires
> having a named cache besides the default data
> cache to bind the table back and forth.
> Regards,
> Mariano Corral
Actually, it works also when you have no named caches: just binding a
table explicitly to the default data cache works just as well.
Unbinding has the same effect again.
You could also use dbcc cacheremove if you're fond of undocumented
dbcc commands, of course.
HTH,
Rob
----------------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.0/11.5/11.0
Author of "The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/qr
WWW http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------