david@smooth1.co.uk wrote:
> use tusc to trace the engine whilst it is doing this.
>
> tusc on HPUX is the equivalent of truss on Solaris.
>
> I can't remember which VP does the exec - probably either the ADM or
> MSC (MISC) VP.
>
Have you tried UPDATE STATISTICS?