Post reply

HELP: PLEASE!!!: Query with to long time execution..

  • January 27, 2009 at 9:03 am

    #933262

    mmm that sounds AWESOME he he he

    Well once again, thanks for help Gail 🙂

    I hope the OP finds this as useful 🙂

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • January 27, 2009 at 10:57 am

    #933387

    Thanks a lot everybody.

    Once more u'll be very useful

    Thanks and regards,

    JMSM 😉

  • January 27, 2009 at 1:53 pm

    #933488

    Add this column:

    IND_ACTIVO

    as an INCLUDEd column to your existing index.

    Otherwise, the query plan looks reasonable.

    It would be better if you didn't convert for the sort, but you will get a different sort order converting vs not converting.

    Btw, I strong suggest you not create (another) nonclus index. Your clus index is (relatively) huge, and SQL will have to add all those columns to any nonclus index you create.

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

Viewing 3 posts - 16 through 17 (of 17 total)

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