 |
 |
Archives of the TeradataForum
Message Posted: Wed, 05 Jul 2006 @ 14:48:53 GMT
| Subj: | | Re: Subtables and Secondary Indices |
| |
| From: | | Damodaran, Manojkumar |
Hi,
| | 1) If we are creating the secondary index by default subtable will be created, my doubt is whether the subtable will be created for each
amp or it will be created for each table. | |
--- The sub table is created based on the table and not on the amp
| | 2) In the Unique Secondary Index - the subtable will be created it will be holding the details about the base table, my doubt whether
where it will be stored, it will be stored in the same amp or different amp. | |
--- I couldn't able to understand your question. But anyway with what I have understood I am replying please let me know if you have any
doubt.
The base table will be stored in the same amp.
Thanks & Regards,
Manoj.
| |
