Archives of the TeradataForum
Message Posted: Thu, 03 Feb 2005 @ 12:48:37 GMT
It's probably just a parser bug ;-)
I definitley wrote something similar, when volatile tables were introduced and it throw an error.
Since then i know about that restriction and never try it again :-)
I just checked it on V2R6: It still doesn't support create/drop index, but your DDL worked.
Then i inserted some rows and used Ferret showb/l: Both subtables exist.
A select using the index column worked like any select without stats: The index is only used for equality, if the Random AMP sample shows a high selectivity.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|