Re: Usage of Temporary Table?

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 15 Sep 2006 10:43:37 -0700
Message-ID: <bf46380609151043q378d4a44x91ddd648e921e633@mail.gmail.com>

On 9/15/06, rjamya <rjamya_at_gmail.com> wrote:
>
> if you have few rows, why bother with indexes? you can easily search for
> sys_context at tahiti.oracle.com, it will yield much more info or at asktom.oracle.com
>
>
>

If the rows are also queried as part of the application usage, indexes will greatly reduce latching and other overhead.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 15 2006 - 12:43:37 CDT