Archives of the TeradataForum
Message Posted: Tue, 15 Jan 2002 @ 13:51:04 GMT
| Subj: || || Re: SQL Tuning - Spool Space Problem |
| From: || || Bill Hassinger |
I have read two responses that I think are good clues.
1) The volitile tables are also using spool, so the final select may not even be reached.
2)With UPI's on all tables, and an inner join, why is the Distinct qualifier needed at all? Couldn't the Select Count(a.ban)?
I find that users have a bad habit of using distinct to keep from anayzing their results for join problems.