Indexes on tables?

[random1]

Are there some general rules of when to use indexes and when not to?

 

- When should they be used?

- What types of indexes are there?

[Zwiter]

Primary keys must be indexed, and are indexed in most of the sgbd, and you set them as primary key.

Foreigner keys should indexed, to optimized join queries.

 

Then it depends on your application. Find some tutirials on that.

In a few word, they will say that you can add indexes on others attribute you use often to search inside a table (WHERE). But the more indexes you have, the worse it gets when you insert a row.

 

 

[fenway]

There are some excellent stickies on this topic.