Serendipity Forums

Posted: **Sat Mar 03, 2007 4:23 pm**

Hi,

my visitors table has two indices defined for the column sessID. They are called sessID and visitorses.

Can I remove one of them, which one is the one that s9y wants to see?

Greetings
Marc

Posted: **Sat Mar 03, 2007 11:36 pm**

Hi!

sessID index can be deleted, I believe visitorses is the one added by recent versions. However having two indexes on the tables doesn'T hurt so terribly much, mysql already optimizes them away.

Regards,
Garvin

Serendipity Forums

Duplicate index for visitor table sessID column

Duplicate index for visitor table sessID column

Re: Duplicate index for visitor table sessID column