Re: ONCHECK -CI

Posted in 2005

Art S. Kagel — Thu, 09 Jun 2005 16:22:13 -0400 — source: Usenet: comp.databases.informix

herbO via DBMonster.com wrote: > Can the message "Index fragment in DBspace" that is returned from the > execution of "oncheck -ci" be eliminated? Dropping the table or the index > and recreating in new dbspaces has not done so for me. Huh? What's the problem? It's just telling you where the index lives! Since it scans fragmented indexes one fragment at a time, hence the terminology. Even if an index is not fragmented it has one fragment! I don't see the problem. Art S. Kagel