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? Quote 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. Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.