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.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to