Dropping DB index on OOB attributes

Is there a way we can drop the index provided by OOB core-items.xml and replace it with a composite key? We want to drop the index on Customer.uid, mark it as non-unique in our custom item type MyCustomer (that extends Customer) and have a composite key on uid and a custom attribute. Is this possible and advisable?