All Forums Database
Ghalia 11 posts Joined 12/15
06 Jan 2016
Primary indexes

Hi everyone,
Can we have more than one primary index on a table ?
 
Regards,
 
Ghalia

kirthi 65 posts Joined 02/12
06 Jan 2016

No, thats not possible. if you really want to access the table through some other column, please create a Single table join index and define primary index on that column. Kindly note this adds extra overhead in terms of space and some CPU while loading data.
 

You must sign in to leave a comment.