Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
"Onstat -g btc" must be a V10 feature, I don't have it available on my
V9.4 instance.
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Art S. Kagel
Sent: Tuesday, June 06, 2006 3:16 PM
To: informix-list@iiug.org
Subject: Re: Checking indexes after large deletes
bozon wrote:
> Good idea to drop the index first. In general this is what I do, but
> this process is part of a job that removes customer data for
> customers that no longer use our product. It is part of a monthly
> cleanup and it happens while the instance is on line.
>
> So is there a way to know if the cleaner is keeping up and
> restructuring the indexes (by removing the keys that are marked
> deleted and then reorganizing the nodes to rebalance the B-Tree?
onstat -g btc
Will show you what index pages have been marked for cleaning. If you
see a preponderence of pages for a single partnum (index or index
fragment) that would be a candidate for a rebuild if you cannot wait for
the Btree Cleaners to catch up.
Art S. Kagel
> Marco Greco wrote:
>
>>bozon wrote:
>>
>>>Is there a way to determine how "messed up" an index is after a large
>>>number of deletes have been done to a table? I searched here and
>>>didn't see anything. Is there an oncheck command or sysmaster table
>>>to look at? If so what values should I look for? I have to make a
>>>case for rebuilding indexes and having hard data would make my case
stronger.
>>>
>>>Thanks.
>>>
>>>_______________________________________________
>>>Informix-list mailing list
>>>Informix-list@iiug.org
>>>http://www.iiug.org/mailman/listinfo/informix-list
>>>
>>
>>Why rebuild the index after you have gone through the effort of
>>marking all those keys as deleted? drop the index first.
>>Caveat: if you are using the index to drive the delete, that might not
>>be a good idea...
>>
>>--
>>Ciao,
>>Marco
>>______________________________________________________________________
________
>>Marco Greco /UK /IBM Standard
disclaimers apply!
>>
>>Structured Query Scripting Language
http://www.4glworks.com/sqsl.htm
>>4glworks
http://www.4glworks.com
>>Informix on Linux
http://www.4glworks.com/ifmxlinux.htm
>
>
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.