Re: LONG in table ?

From: Giorgio <G.Sorbara_at_fake.soft.it>
Date: Mon, 29 Mar 1999 10:48:17 +0200
Message-ID: <7dndvr$8lr$1@fe2.cs.interbusiness.it>

Hi,

I had the same problem.
Check the execution plan for the query !! As far as i know LONG columns are stored within the object segment, so if the
execution plan for that query is 'full table scan' oracle has to fetch all the blocks
within the segment.
Force oracle, with hints in your statement, to use the primary key.

Giorgio

[...]
>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 Mon Mar 29 1999 - 02:48:17 CST