Secondary Index usage

Database

Secondary Index usage

Is there a way to see how many times or at what times a secondary index was used?
3 REPLIES
Enthusiast

Re: Secondary Index usage

The "explain" feature gives the execution path of a query, telling you which indexes are used and when they are used.

E.G.: explain select * from dbc.tables;
Enthusiast

Re: Secondary Index usage

You may know this just an FYI
Use Index Wizard for recommendations on existing workload or a new SQL.

Vinay

Re: Secondary Index usage

QUERY ON SECONDARY INDEX:

Hi Friends ,

I was new to this teradata and its related concepts .

clear my doubts for the following things ...

1.Why we use secondary index ? How S.I effects

the performance ?

2.How  many Secondary indexs can be created ?

with respective to the versions ?

3.Is it possible to access the Sub-Table of a

Secondary Index ? and What type of table (ex:set

table or multiset table...etc ) is Sub-table in S.I ?

4.In which memory will the sub-table store (Temp 0r perm)?

5.What is the structure of a SET table ?

plz clarify my quries .....