Hi,
I am trying to increase my DB speed because its it so big it has gotten very slow, I will be this by indexing the large tables,
my issue is that i am getting it wrong with the correct syntax and need your help, shown below is an example of what i am trying to do.
CREATE TABLE people (
name VARCHAR(32),
dob DATE,
unique INT, INDEX (id)
)
after the table is created.
To add an index to an existing table, the following would be used.
ALTER TABLE people (
ADD INDEX id(unique),
ADD INDEX name(name);
)
But I cant seem to get the syntax right when i try to this with the piwik DB, I am trying to index resource hungry tables,
can you show me the correct syntax and the suggested tables to attack please.
kind regards
Phillip