Viewing 2 posts - 16 through 17 (of 17 total)
sql-plans in attachment ...
How can I delete this post ... ?
November 30, 2010 at 6:04 am
#1256726
Yes, the index covers both columns - so it SHOULD be used for selection:
CREATE NONCLUSTERED INDEX [pw_test] ON [dbo].[objkeys]
(
[okeyname] ASC,
[okeydata] ASC,
[parentid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...
November 30, 2010 at 4:33 am
#1256692