|
|
|
Junior Member
 
Group: Forum Members
Last Login: 9/23/2008 3:15:52 PM
Posts: 18,
Visits: 10
|
|
When is NUPI preferred over UPI? and When is UPI preferred over NUPI?
What are the advantages of one PI over the other?
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/25/2007 12:04:00 AM
Posts: 17,
Visits: 1
|
|
A primary index is defined to be either unique or nonunique.
Major entities and subentities are typically assigned unique primary indexes. When a subentity has been defined in the logical model, it typically uses the same unique primary index as the major entity it is associated with. This ensures that related rows from the two tables always hash to the same AMP.
Minor entities are typically assigned nonunique primary indexes defined on the same column as the Major entity with which they are associated.
for additional info Refer Teradata Techincal Documentaion on Database Design Chapter 10.
Regards
Abhijit Vyas
Teradata Certified Master (V2R5)
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/25/2007 12:04:00 AM
Posts: 17,
Visits: 1
|
|
A primary index is defined to be either unique or nonunique.
Major entities and subentities are typically assigned unique primary indexes. When a subentity has been defined in the logical model, it typically uses the same unique primary index as the major entity it is associated with. This ensures that related rows from the two tables always hash to the same AMP.
Minor entities are typically assigned nonunique primary indexes defined on the same column as the Major entity with which they are associated.
for additional info Refer Teradata Techincal Documentaion on Database Design Chapter 10.
Regards
Abhijit Vyas
Teradata Certified Master (V2R5)
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/25/2007 12:04:00 AM
Posts: 17,
Visits: 1
|
|
A primary index is defined to be either unique or nonunique.
Major entities and subentities are typically assigned unique primary indexes. When a subentity has been defined in the logical model, it typically uses the same unique primary index as the major entity it is associated with. This ensures that related rows from the two tables always hash to the same AMP.
Minor entities are typically assigned nonunique primary indexes defined on the same column as the Major entity with which they are associated.
for additional info Refer Teradata Techincal Documentaion on Database Design Chapter 10.
Regards
Abhijit Vyas
Teradata Certified Master (V2R5)
|
|
|
|