Re: Unique Index Disk Consumption

Ron <ronljohnsonjr@xxxxxxxxx> · Wed, 27 Mar 2019 08:59:54 -0500



    On 3/27/19 8:50 AM, Moin Akther wrote:

    
        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.