> > > With an IOT I don't understand how you get out of index corruption > without data loss. That's a showstopper for practical use, I think. >
For simplicity, say we are storing all the non-leaf pages of the index in a seperate file, then the leaf pages are nothing but the table. So if we can replicate the table, then we can replicate the non-leaf pages (say by some modified version of reindex). Thanks, Gokul.