At 01:21 PM 6/24/2009, you wrote:
I have an application in which I'm getting occasional weirdness in
the indexes for one particular table, leading to incorrect results
on some queries.
I've been able to fix this with other users on-line by using the
PACK INDEX <IndexName>. It's a big help to be able to do this with
users in the system.
Unfortunately, that only helps me AFTER the users have experienced
and noticed the problem. I'm thinking of implementing an automatic
PACK INDEX routine to run at night to catch these things in
advance. This database runs 24 hours, but it's less busy at
night. My only concern is that by rebuiling these indexes
repeatedly, my #3 file will grow in size.
Does anyone have experience with this? Is that what happens? Or
does R:Base somehow recycle the space currently used by an index?
Larry,
Please refer to the "Pack Keys Versus Pack Index"
document at: http://www.razzak.com/fte/
John
