January 27, 2009 at 9:03 am
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]
January 27, 2009 at 10:57 am
Thanks a lot everybody.
Once more u'll be very useful
Thanks and regards,
JMSM 😉
January 27, 2009 at 1:53 pm
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) "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 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply