Re: SORTINDEX capability (Was: re: large DB Problems)

In article <9196@emory.mathcs.emory.edu> carsmax!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein) writes: >What is SORTINDEX capability, how do we know if our 4.10 version has it, Properly known as "Fast Index Build"... >how do we know if our 4.10 version has it, >is it documented somewhere and if not, how do we use it? It's in 4.10.UF1 (and higher) versions of OnLine, and in a few U[DE][2-9] versions as well. Check your machine-specific notes in $INFORMIXDIR/release for an entry under "bug 10990". If it's there, then sortindex capability exists. I just checked the on-line doc files, and it's not mentioned for the 4.10 releases, so it's an undocumented feature in 4.10 (oops). Check with your support rep to see if its usable on your platform, and if so, s/he can tell you how to activate it. In 5.0 and above, Fast Index Build is the default, and you can shut it off (not that you'd want to) by setting NOSORTINDEX in your calling environment. -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "This song is a traditional bluegrass number, in the sense that it's about dead ancestors." - The Austin Lounge Lizards (live, introducing "Grandpa's Hologram")