Please share it.

-----Original Message-----
From: Gentsch, Sam [mailto:sgentsch@intercall.com]
Sent: Wednesday, June 07, 2006 4:11 PM
To: Hamilton, Jerry; informix-list@iiug.org
Subject: RE: Checking indexes after large deletes


I received an interesting email concerning BTSCANNERS from a kind man at
IBM Tech support....kind of a question and answer document.

Would I be hung and quartered for sharing it with folks that ask me?

Also Neil has some very good information on the subject...on his web
site.

--
Sam Gentsch


-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Hamilton, Jerry
Sent: Wednesday, June 07, 2006 3:09 PM
To: informix-list@iiug.org
Subject: RE: Checking indexes after large deletes



Yes I was interested in this too.

I think a blue person came on here and said, "If you put this line in
your onconfig, all your problems with the b-tree scanner will be
forgotten". So I did and I forgot all about my b-tree scanner. But I
still don't know what the heck it's doing.

BTSCANNER num=1,priority=low,threshold=50000,rangesize=10000

----Original Message-----
From: Gentsch, Sam [mailto:sgentsch@intercall.com]
Sent: Wednesday, June 07, 2006 4:11 PM
To: Hamilton, Jerry; informix-list@iiug.org
Subject: RE: Checking indexes after large deletes

>> I received an interesting email concerning BTSCANNERS from a kind man at
>> IBM Tech support....kind of a question and answer document ... Also Neil
>> has some very good information on the subject...on his web site.

http://www.informix-support.co.uk/btscanner.htm