Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: number of extents question

Re: number of extents question

From: Yong Huang <yong321_at_yahoo.com>
Date: 12 Sep 2002 09:30:16 -0700
Message-ID: <b3cb12d6.0209120830.4e39e409@posting.google.com>

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<3d7f5b6a$0$1294$cc9e4d1f_at_news.dial.pipex.com>...

> when appropriate. LOB's on the other hand are a big advance over longs. If
> you don't use longs then fair play. if you do use longs then LOB's perform
> better are easier to code for and can be accessed easily through sql and
> PL/SQL. Longs and especially LONG RAW have had their day.

Hi, Niall,

Metalink notes 74658.996 and 165338.995 seem to say LONG actually is faster than CLOB and LONG RAW faster than BLOB. I need to

Benefits of LOB over LONG (RAW) are still obvious though. And LOB performance issues may have improved over the past 1 or 2 years.

Yong Huang Received on Thu Sep 12 2002 - 11:30:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US