Secondary Index usage

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Secondary Index usage

Rate Topic

Display Mode

Topic Options

Author

Message

ak_tdata

Posted 6/9/2006 5:39:45 AM

Forum Newbie

Group: Forum Members
Last Login: 6/19/2006 3:36:00 AM
Posts: 2, Visits: 1

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

.AK

Post #4345

Daniel Giabbai

Posted 6/11/2006 7:40:11 AM

Supreme Being

Group: Forum Members
Last Login: 7/22/2008 3:48:36 AM
Posts: 173, Visits: 5

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;

Post #4351

Vinay Bagare

Posted 6/16/2006 11:38:31 AM

Supreme Being

Group: Forum Members
Last Login: 7/5/2009 2:58:22 PM
Posts: 134, Visits: 13

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

Vinay

Post #4385

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 10:34am