RE: Long raw-access speed

You can move the long raw column to form it's own table with a one to one relationship back to the original table.

Richard Ji

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Trassens, Christian
Sent: Tuesday, January 16, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Long raw-access speed

Try with BLOBs.

Regards.

> -----Mensaje original-----
> De: OLCAY YENILMEZ( EBI Bsk.-Sistem Prog.) [SMTP:OYENILMEZ_at_thy.com]
> Enviado el: martes 16 de enero de 2001 10:20
> Para: Multiple recipients of list ORACLE-L
> Asunto: Long raw-access speed
>
> I have a table which contains long-raw type data. It contains about 20000
> rows. There is a defined primary key. When I query this table, because of
> the long-raw data, it gives response to late...
> How can I increase the speed to access for this table?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: OLCAY YENILMEZ( EBI Bsk.-Sistem Prog.)
> INET: OYENILMEZ_at_THY.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).