Indexes are really important because we need them for performance reasons especially for the batch system. Indexes are supported today by every database system. The only difficult thing is that some vendors implement them in a really table dependent way. If you cleanup your database please always remove the indexes first. If you remove the tables before the indexes then it can happen that you cannot remove the indexes from the database.