Thunderstone Support Forums

When running a tsql "create index" command, is there a any way to tell how far along the process is?

If not, is it possible to run the index in some other way and retrieve a rough status along the way? Thanks!

indexmeter. See http://thunderstone.master.com/texis/ma ... 3cf7b9ca13

I've tried indexmeter before, I think, and I've never gotten any status out of it. Maybe I'm not setting it correctly?

For instance, if I run this command from my Solaris prompt:

tsql "set indexmeter=1;create unique index myindex
on mytable(FIELD01)"

The index is created eventually, but I don't see any % complete messages.

indexmeter only applies to metamorph indexes. For regular indexes you would need to watch the size of the index compared to either one on a similar field that already exists, or an estimate of the final index size.

Ah, that explains it-- metamorph only. Cool, thanks.

One more thing, if I could; there's no way, I suppose, to add the index name to the status report? So that it reads something like "Indexing data <<for index01>>:"? Any optional parameters I can pass into the statement?

indexmeter applies to all indexes -- including regular and inverted -- in Texis versions after Aug. 10 2002; it was Metamorph-only previously. There's no way to alter the status messages printed.