- creating index when the table is created
- retrieve the primary key as a index