multiple indexes on a single table? ok? good?

[bunner_bob]

Is it ok/wise to create multiple (non-fulltext) indexes on a table with a lot of data?

For instance, on some pages I look at "project_id", other pages look at "employee_id", and still others use one of several possible combinations of keys.

I'm not too concerned about storage space - gigs are cheap, time is not. So not worried about size issues of creating many indexes on a table.

So, is this a smart thing to do?

• Bob

[bastien]

Yes, its fine. Indeces created should match the where clauses in the sql statements