Index creation date
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. Thank you. _______________________________________________________________ Is there any way to find out the creation date for an index? TIA
For detached indexes (all indexes in v9.2), try the following
database sysmaster;
select indexname, l2date(ti_created )
from sysmaster:systabinfo a, <db>:sysfragments b
where a.ti_partnum = b.partn
and b.indexname = '<whatever>';
Also, oncheck -pt <db>:<table> will give you info.
Rudy
"Colleen M. Morrow" wrote:
> _______________________________________________________________
>
> This message and any attachments are intended for the individual or entity
> named above. If you are not the intended recipient, please do not read,
> copy, use or disclose this communication to others; also please notify the
> sender by replying to this message, and then delete it from your system.
> Thank you.
> _______________________________________________________________
>
> Is there any way to find out the creation date for an index?
>
> TIA