We're attempting to extract file name and size information from the
database with SELECT.  It appears the data we want is in the CONTENTS
table.  The SELECT command takes an excessive amount of time to return when
not using the table key, VOLUME_NAME.

Is it possible to add an index to a TSM database table?  How does the
client (eg Windows) return active file information so quickly?

thanks!

Jay Jackson
University of Buffalo
tksjwj AT buffalo DOT edu