On 3/27/19 8:50 AM, Moin Akther wrote:
P {margin-top:0;margin-bottom:0;} 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 big is each row?
Are the rows compressible?
How big are PK fields?
How can i manage this kind scenario ? as droping and recreating unique index on the existing data is taking lot of time.
Why do you
need to?
--
Angular momentum makes the world go 'round.