We are experiencing network problems with the site. Some functions may be temporarily unavailable. Please bear with us while we work to resolve these issues.
All Forums Database
ak_tdata 2 posts Joined 06/06
09 Jun 2006
Secondary Index usage

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

Daniel Giabbai 42 posts Joined 07/04
11 Jun 2006

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;

Vinay Bagare 96 posts Joined 12/04
16 Jun 2006

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

Vinay

You must sign in to leave a comment.