Post reply

When we insert new data into Compressed table, is it automatically compressed?

  • March 29, 2021 at 10:29 pm

    #3863401

    With data compression, let's say we already have a compressed table. Page or Row compression applied to all indexes.

    When we insert new data is it automatically compressed, or only when we rebuild the clustered index?

    Likes to play Chess

  • March 30, 2021 at 2:34 am

    #3863457

    When a page gets full, it is compressed(*), there does not have to be a rebuild first.

    (*) SQL attempts to compress the page; if there's not enough gain from compression, SQL may decide not to compress that specific page, but it would if compression was beneficial enough for that page

     

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply