O'Reilly logo
  • Victoria Salekin thinks this is interesting:

You can create multiple indexes on the same table, but you must use a separate CREATE INDEX statement for each index that you want to create.

From

Note

Ask Sam or another architect about multiple indexes. If you have two indices, are you essentially storing two instances of the same table, presorted according to the corresponding index?