Is it possible? What's the process for it?

Some of the tables on db1047 I'm dealing with are getting massive (the main offender is 27.8GB) and some of our daily queries used to build tsvs are badly in need on indexes.

The SQL credentials I have access to don't have the rights to alter those tables.