RE: Checking indexes after large deletes

Posted in 2006

Hamilton, Jerry — Thu, 8 Jun 2006 10:07:15 -0500 — source: Usenet: comp.databases.informix

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