Re: time of select

From: Andreas Koch <akoch_at_rbg.informatik.tu-darmstadt.de>
Date: Mon, 16 Oct 2000 23:52:11 +0200
Message-ID: <39EB788B.A68F4A30@rbg.informatik.tu-darmstadt.de>

Connor McDonald schrieb:

> > how can i know how long a "select max(mycol) from myview" will take -
> > BEFORE it is finished?
>
> You could issue an explain plan and check the estimated rows count and
> make an educated guess from that...

The problem is, the select will return ONE row.

-- 
                                                 Andreas
Techniker:Nein, dieser Kopierer hat keinen automatischen
Einzug. Das sind die Lüftungsschlitze.

Received on Mon Oct 16 2000 - 16:52:11 CDT