I would like to know if it's interesting to create an index on an other column than the geom one.
In some cases, I would like to do spatial analysis. If not, I would like to analyse only attributes.
So, should I make a second index on an alpha/numeric field?
EDIT: The practical case is few inserts (adn feature by feature) and a lot of selects on spatial or attributes (one main field as an ID (int) ) or both