I've a table FRM with column LOGO of type LONG which contains bitmap images.
Table FRM has structure like this :
ID NUMBER
NAME VARCHAR2
CITY VARCHAR2
...
LOGO LONG
When I issue SELECT statement after creating table and without any images in
column LOGO, I get result very quickly. I've inserted a bitmap image into
table (about 1 MB).
Now SELECT name FROM FRM takes about 1 second. I changed image in LOGO
column to smaller one (30 KB) but SELECT statement is still slow ! Even when
I insert NULL into LOGO column it doesn't metter. Truncating table
(TRUNCATE) doesn't help. I have to recreate table to speed up response.
May be there is another way to do it ?
Jarek Palka
Kamsoft, Katowice
POLAND
Received on Fri Mar 26 1999 - 08:25:37 CST
