Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunny Gain Space Using XML data type RE: Gain Space Using XML data type

  • August 4, 2009 at 6:45 am

    #1034202

    If you make your primary key in both tables CLUSTERED (which would be a reasonable choice in this case given that some of the queries are ORDERing/GROUPing by locid), the storage requirements are somewhat different... XML now uses more storage.

    name rows reserved data index_sizeunused

    Rainfall_XML 36600 36744 KB 36600 KB 112 KB32 KB

    name rows reserved data index_sizeunused

    Rainfall_Con 878400 27080 KB 26928 KB 96 KB56 KB