Query 1: select * from descriptionkeywordlookup where keyword = 'X' or keyword = 'Y'

Query 2: select * from descriptionkeywordlookup where keyword like 'X%' or keyword like 'Y%'

TABLE Definition:

CREATE TABLE [dbo].[DescriptionKeywordLookup](

[Keyword] [nvarchar](255) NOT NULL,

[ItemId] [int] NOT NULL,

CONSTRAINT [PK_DescriptionKeywordLookup] PRIMARY KEY CLUSTERED

(

[Keyword] ASC,

[ItemId] ASC

)

)

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

Execution Plans attached.

Runtime for WHERE = is 27s

Runtime for WHERE Like is 1m36s

Thanks everybody for your comments and insight.

What's the reason why the distributor should be on the publication side? I'm sorry to admit I know next to nothing about the inner workings of replication.

jared-709193 (11/15/2011)

---

aurato (11/15/2011)

---

jared-709193 (11/15/2011)

---

Now we understand your real concern. You don't want indexes there that are unused because you feel that it may affect performance. Let me ask...

Ninja's_RGR'us (11/15/2011)

---

I think you'd be better off starting a new thread with replication getting 1 hour behind as the title.

You'll get better help that way to solve your real issue...

It's fine. You've been extremely cordial in all my other threads...

jared-709193 (11/15/2011)

---

Now we understand your real concern. You don't want indexes there that are unused because you feel that it may affect performance. Let me ask you this......

jared-709193 (11/15/2011)

---

Ok, so how do you know those indexes are not being used. The query you gave us is not going to tell you if these are used or not....

Ninja's_RGR'us (11/15/2011)

---

You've clearly made up your mind, even before coming...

jared-709193 (11/15/2011)

---

Can you tell us the primary reason for you wanting to drop these? Are you annoyed with the amount of indexes or are you running out of space? Obviously...

I still wouldn't want them there if they're not being used.

jared-709193 (11/15/2011)

---

aurato (11/15/2011)

---

Well, the create date of tempdb is September 7, 2011 and of the five indexes that don't have any user seeks/scans/lookups 4 of them don't have any system...

Ninja's_RGR'us (11/15/2011)

---

I can't make that call for you....

As for proving a benefit, there's 9 indexes on this table and if four never get used they're just dead weight objects.