On 6/28/07, Henrik Wahlstedt <SHWL AT statoil DOT com> wrote:

Hi,

Well, the backups table is rather large....  Which you have noticed.

To run selects efficiently against backups table you need at least to
specify node_name='XYZ' and filespace_name='\\XYZ\c$\'.

Thanks Henrik!

You are right stating that the table is big, but still why does it
take so long for the prompt to reappear? I mean what prevents it from
dropping the table lookup right away and giving me back the prompt?
--
Warm regards,
Michael Green