That'll depend on the usage patterns of the particular database and table.  If it's a table that's only used for month end reports, you shouldn't go dropping indexes if they haven't been used for two weeks. On the other hand, if it's your main order details table then you'll probably know much sooner that an index isn't of any use.

John