> Why would I or would I not create multiple indexes in a table? I
> created another index in the same table an it's improved performance
> even more.
You create indexes when you need indexes. Indexes are most helpful when
they match the WHERE clause of your selects.
So, if you commonly do one query that selects on one column, and another
query that selects on two other columns - then create one index on the
first column and another index over the second two columns.
Chris