Subject: Re: Query optimization problem on CA-Ingres 6.4/06 (vms00)
Date: 26 Jul 1996 07:42:21 -0400

On Jul 25, 14:58, MDKale wrote:
> [snip]
> Incidentally, I also ran into another problem (or so I think) having to do
> with compressed heaps.  If a row is updated and becomes shorter, it moves
> to the end of the heap.  DBA guide says otherwise.  I also ran this script
> on 6.4/04 (vms) and found same problem.  If the row is updated to exactly the
> same size, it does not move.  I could have sworn this used to work before.
> Any comments?

6.4 has always moved the row if it changes size, whether it shrinks
or expands.  I ran into this about 4 years ago (I still have my workaround
code).  It's stupid, and I should have reported it, but I had my hands
full at the time with other stuff.

-- 
Karl Schendel            Phone: (412) 963-8844
Telesis Computer Corp      Fax: (412) 963-1373
wiz@telesis.com

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William