Tom Conlon wrote:

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

I'm afraid that a reboot is the only sure way to clear out the OS
file system cache.

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

In ISQL, there's SET PLANONLY ... which prepares the query without
executing it.

Regards,


Ann