Should I add an index

[tibberous]

If I have a table with a many to one relationship, should I add an index to speed it up?

 

ratings -> products

 

And products have multiple ratings. And ratings have an `Owner` field.

 

And what would the syntax be?

 

create index `identifer` on ... ?

 

Thanks

[JonnoTheDev]

Simple answer: yes

 

If your are using joins on the products to ratings

So your ratings table should have an index on productId

 

// example

ALTER TABLE ratings ADD INDEX (productId)