Re: SQL-question

Garry M. Filimonov wrote:
>
> Doctor Stan <76305.324_at_compuserve.com> wrote in article <323F1869.68CA@compuserve.com>...
> > I have writte 4 statements and I don't know which one is best for
> > perfomance.
>
> More simply:
> sqlplus
> SQL> set timing on
> ... and run your statments
>
You can to use package function DBMS_UTILITY.GET_TIME for getting time with precision 1/100 second. This method was offered by Steven Feuerstein in his book "PL/SQL Programming".

Victor Abramov
Moscow, Russia
abr_at_ivcais.msk.ru Received on Fri Sep 20 1996 - 00:00:00 CEST