Index number

Teradata Studio
Junior Supporter

Index number

I cannot find the index number in the latest version of Studio (15.12, Mac).  Are index numbers available?  They're important when viewing explain plans.

3 REPLIES
Senior Apprentice

Re: Index number

HELP INDEX mytable; returns index numbers
Junior Supporter

Re: Index number

Thanks for the reply.  My post was focused on Studio because there is a way to see all indexes for a table, but it's missing the index number.  Studio is a pretty big product, and it may be that I just couldn't find it in Studio.  If it's not there, I think it should be added to the index information screen.

 

G.

Teradata Employee

Re: Index number

With the Administrator perspective, some of the items from the Object Viewer are still being implemented. Showing the details for an Index (such as the Index Number) was one of them. We hope to have this resolved in our next release.