Long Raw field in table
Date: 10 Mar 1994 09:50:14 -0500
Message-ID: <2lnc36$daq_at_ucunix.san.uc.edu>
I was wondering if anyone out there has experienec with long raw
columns in tables. We created a table with one long raw column to
store binary information. The problem is that any activity on that
table takes an enormous amount of time. For example if we do a select
count(*) via sqlplus when the table has about 50 rows, it takes almost
5 minutes for the query to come back ! The table is indexed on a NUMBER(6)
column and it seems that Oracle does something internally when dealing
with such tables which slows down the queries. No response yet from Oracle
(we have a TAR for this).
We would appreciate if anyone can share their experieneces with such tables.
We are running Oracle 7.0.15.1 on Netware 3.11.
Thanx
Sailaja Baljepalli
baljepsu_at_ucunix.san.uc.edu
Received on Thu Mar 10 1994 - 15:50:14 CET