Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: OLTP help
On 8/18/06, Herring Dave - dherri <Dave.Herring_at_acxiom.com> wrote:
>
> Thanks Jared. This table is primarily accessed to retrieve one row at a
> time, to update a status of a particular job, for example. This really
> should be indexed as there's no need to scan all 100k rows multiple times
> per minute. With an index it'd be hitting a block at a time instead of
> multi-blocked read of 1M. Why busy the cache way more than necessary,
> especially with hundreds of updates a day, causing the blocks to be flushed
> out.
>
I missed that in the original post. Like I said, it's Friday.
Yes, an index is probably in order.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 18 2006 - 12:09:57 CDT
![]() |
![]() |