Archives of the TeradataForum

Message Posted: Wed, 03 Feb 2005 @ 04:12:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The Teradata manuals are normally accurate. SPOOL space does not support any form of secondary indices. Since volatile tables are created in SPOOL space there are no answers to your questions regarding the creating or dropping of a secondary index on a volatile table.

If you need secondary index definitions on a temporary table use a Global table which is materialized in TEMPORARY space, which does allow secondary index definitions.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>