Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: number of extents question
"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