Re: Full Table Scans

From: Ken Geis <kgeis_at_cchemnt.cchem.berkeley.edu>
Date: Wed, 11 Nov 1998 18:54:20 -0800
Message-ID: <364A4DDC.24CA8AAD@cchemnt.cchem.berkeley.edu>

I can't believe that it does. You should post the results of an EXPLAIN PLAN. Note that sorting without indexes is not trivial for a large table.

Ken

Roman Gelfand wrote:
>
> I am trying to execute a select statement querying against a single table
> without a where clause and sorting by two columns.
>
> Can anyone tell me why does this statement causes recursion when executed?
>
> Thanks,
>
> Roman
Received on Wed Nov 11 1998 - 20:54:20 CST