There is a tool called as Teradata performance monitor which will show you the execution status
Attachments
Library
Quick Reference
Archives
Sample Index
2008 Indexes