Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Temp tables vs "permanent" temp table vs User Table Type RE: Temp tables vs "permanent" temp table vs User Table Type

  • September 19, 2013 at 10:43 pm

    #1651760

    Srinivasan Raju (9/19/2013)

    Why don't you use XML Indexes?

    References:

    http://technet.microsoft.com/en-us/library/ms191497.aspx

    http://technet.microsoft.com/en-us/library/bb934097.aspx

    XML with indexes is very slow and takes lots of memory.

    I've made some tests with XML without index, with indexes and data stored "vertically" (to store data in a database where the user can define whatever they want) and XML was always very very slow no matter what.

    The best way to use XML, in this case, a very large XML, is to store it in temp table.


    If you need to work better, try working less...