Post reply

XML Column - Table Processing takes forever

  • July 17, 2008 at 2:10 am

    #189698

    Hi people [Smile]

    I have a table that contains an XML column with a huge xml string in it.

    Problem is a normal 'select * from ' takes about 8mins to process.

    I writing a stored procedure that interacts with this table and strips

    xml for certain values, needless to say the stored procedure takes forever

    to execute (8min)...

    what are my options in tuning the table or stored procedure?

    i.e table is already indexed, and even using NOLOCK it still take forever and

    a day to execute a normal select * from...

  • July 17, 2008 at 3:08 am

    #844212

    Select * From will do a full table scan, so indexes wont be used.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • July 17, 2008 at 3:33 am

    #844224

    hi,

    yisaaacs

    ---------------------------------------------------------------------------------------------------

    I have a table that contains an XML column with a huge xml string in it.

    Problem is a normal 'select * from ' takes about 8mins to process.

    I writing a stored procedure that interacts with this table and strips

    xml for certain values, needless to say the stored procedure takes forever

    to execute (8min)...

    what are my options in tuning the table or stored procedure?

    you can create a XMl index on the xml column and check it.

    I think, you no need to tune the SP because your select query takes the time.

    Check wid XML index, it may help you..

    Cheers!

    Sandy.

    --

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

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