Adding indexes for performance?
July 4th, 2009
Here's what was suggested:
alter table forum add index (displayorder);
alter table forumpermission add index (forumid);
alter table forumpermission add index (usergroupid);
alter table forumpermission add index (canadminedit);
alter table post add index (threadid);
alter table post add index (username);
alter table post add index (userid);
alter table post add index (dateline);
alter table session add index (userid);
alter table session add index (location);
alter table thread add index (lastpost);
alter table thread add index (forumid);
alter table thread add index (lastpost);
If this is still a good idea, what're the pros and cons of it?
You should not have more indexes than necessary as it will actually slow down your database and increase the chances of database corruption, not to mention will grow the size of the database.
#If you have any other info about this subject , Please add it free.# |
