Re: Explain Plan For Query

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 12 Apr 2002 09:47:39 +0100
Message-ID: <3cb69f2b$0$232$ed9e5944@reading.news.pipex.net>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:3vgbbucc07vml3rnn5fsqejt5am8eds5nl_at_4ax.com...
> The default optimizer goal for pl/sql is ALL_ROWS

I knew that.

> ALL_ROWS
> retrieves the complete resultset in SGA
> favors full tablescans.

But I didn't know that. Is this difference documented/demonstrated somewhere?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Fri Apr 12 2002 - 03:47:39 CDT