How to find if SI is used?

Database
Highlighted
KN
Enthusiast

How to find if SI is used?

Hello Team

 

How do i find if my secondary index is being used from the DBC tables?  I know i can find that out from Explain plan. However anything that we could get the list of all the SI usage across the tables from teh metadata itself? 

 

Note we are on 15.10 and we have not enabled the DBQLOBJ table.

 

Thanks

KN

1 REPLY 1
Teradata Employee

Re: How to find if SI is used?

Sounds like you may already know the answer.

You need to have DBQL OBJECTS or USECOUNT logging enabled, or look at the EXPLAIN.