Any way to guess when indexing will be done?

jkj2001 · Post by **jkj2001** » Wed Jan 29, 2003 11:03 am

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!

Post by **mark** » Wed Jan 29, 2003 11:58 am

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

jkj2001 · Post by **jkj2001** » Wed Jan 29, 2003 1:09 pm

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.

Post by **John** » Wed Jan 29, 2003 10:41 pm

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.

jkj2001 · Post by **jkj2001** » Thu Jan 30, 2003 1:11 pm

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?

Post by **Kai** » Thu Jan 30, 2003 3:09 pm

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.