Re: Measure querytime
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 8 Jul 2002 18:05:02 -0700
Message-ID: <92eeeff0.0207081705.6c9a3e7_at_posting.google.com>
Date: 8 Jul 2002 18:05:02 -0700
Message-ID: <92eeeff0.0207081705.6c9a3e7_at_posting.google.com>
"Christina" <christina.kronblad_at_telia.com> wrote in message news:<p1VV8.15136$p56.4914941_at_newsb.telia.net>...
> Hi,
> how can I measure time for a sql-query?
>
> /Christina
If your objective is to tune a particular query or queries, then you
should use EXPLAIN PLAN statement and TKPROF utility. There is a good
document on it by Roger Schrag at
http://www.dbspecialists.com/presentations/use_explain.html
HTH
//Rauf Sarwar
Received on Tue Jul 09 2002 - 03:05:02 CEST