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
Duplicate index for visitor table sessID column
-
Zugschlus
- Regular
- Posts: 144
- Joined: Sun Feb 05, 2006 12:54 am
- Location: St. Ilgen, Germany
- Contact:
Duplicate index for visitor table sessID column
--
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Duplicate index for visitor table sessID column
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/