Subject Clearing DB/OS Cache completely + See Plan before Query execution
Author Tom Conlon

Whilst testing some queries is there a way to clear the DB (and
perhaps OS) cache *completely*.

I've tried disconnecting from the database and restarting the service,
but the first 'cold' run of certain queries still run quick - unless
I completely reboot the machine.

Also, is there a way of seeing the plan to be used *without* actually
going onto to run the query against a large table?