Dear Experts,
on a table we have 2 unique index's and when i check the table and unique index size, size of index's are twice the size of table.
if have drop both the unique index's and create the new one but again after some time index size is almost twice the size of table.
Is Unique Index consume more disk space ?
How can i manage this kind scenario ? as droping and recreating unique index on the existing data is taking lot of time.