 |
 |
Archives of the TeradataForum
Message Posted: Wed, 05 Jul 2006 @ 19:29:20 GMT
| Subj: | | Re: Subtables and Secondary Indices |
| |
| From: | | Dieter Noeth |
Subrahmanian Kalyanasundaram wrote:
| | I have some doubts in secondary indexes | |
| | 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. | |
| | 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. | |
All yours doubts will vanishe if you listen to the words of wisdom as published within the books :-)
Database Design
Chapter 11: Secondary Indexes
Dieter
| |
