We do use indexes on various fields throughout the database for better performance. However, any modifications to product or database will have to be done at client's own risk and support cannot be guaranteed for those changes.
If you still want to go ahead with it, I would suggest taking a backup of existing database before making any changes.
