Another reason for excessive runtimes might be index maintenance.
Best regards,
Tom Fastner Senior Consultant Teradata Certified Master
Attachments
Library
Quick Reference
Archives
Sample Index
2007 Indexes