Re: time of select

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 16 Oct 2000 18:31:59 +0800
Message-ID: <39EAD91F.3E8D@yahoo.com>

Andreas Koch wrote:
>
> Hi,
>
> how can i know how long a "select max(mycol) from myview" will take -
> BEFORE it is finished?
>
> --
> Andreas
> Techniker:Nein, dieser Kopierer hat keinen automatischen
> Einzug. Das sind die Lüftungsschlitze.

You could issue an explain plan and check the estimated rows count and make an educated guess from that...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me... 
  its the voices in yours.

Received on Mon Oct 16 2000 - 05:31:59 CDT