roopurt18 Posted September 27, 2007 Share Posted September 27, 2007 I've got several tables in a database that have a PRIMARY KEY assigned to a column as well as a UNIQUE or regular index on the same column. Am I right to assume that I can delete the UNIQUE and INDEX indexes on these columns and just keep the PRIMARY one? Link to comment https://forums.phpfreaks.com/topic/70970-solved-multiple-indexes-on-a-column/ Share on other sites More sharing options...
Barand Posted September 27, 2007 Share Posted September 27, 2007 Yes, it's just duplication to have those. A PK is a UNIQUE index. Link to comment https://forums.phpfreaks.com/topic/70970-solved-multiple-indexes-on-a-column/#findComment-356808 Share on other sites More sharing options...
roopurt18 Posted September 27, 2007 Author Share Posted September 27, 2007 Thanks! Link to comment https://forums.phpfreaks.com/topic/70970-solved-multiple-indexes-on-a-column/#findComment-356810 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.