rocho09 (5/28/2015)

---

Hi, thank you for your response. I already upload the execution plan and here are the index definition, table definitions are above, please look into my first post.

CREATE NONCLUSTERED INDEX [IX1] ON [dbo].[VendorBreakout]

(

[lenprefix] ASC

)

INCLUDE ( [VendorName],

[Prefix],

[Cost]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO

CREATE NONCLUSTERED INDEX [IX2] ON [dbo].[RepSheet0_]

(

[Cost] ASC

)

INCLUDE ( [Vendor],

[DialedNumber]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO

Regards