Chapter 34 – Creating Tables, Secondary Indexes, and Join Indexes
“Create a definite plan for carrying out your desire and begin at once, whether you are ready or not, to put this plan into action.”
Creating a Table with a Unique Primary Index
This is a basic TABLE CREATE STATEMENT. You have Columns and the data types in them. As you see, the Primary Index is defined for a Table at TABLE CREATE time.
Creating a Table with a Non-Unique Primary Index
A Non-Unique Primary Index (NUPI) is on the above table. Notice how ...