I am getting spool space error while trying to join 3-5 views that are accessing same underlying tables.
Teradata optimizer is using the intermediate spool result in stead of the actual view output while joining. As a result, it is using much more data which would otherwise be filtered out in the join conditions inside view definiton.