David Crowell asked about the indexes on T_PHONE via the old Tessnet Technical email list.
Here are the indices on my copy of T_PHONE. Hope this helps. There should also be two keys and one constraint on your table, David. You might want to check for those.
USE [impresario]
GO
/****** Object: Index [IND_t_phone_address_no] Script Date: 03/25/2009 15:41:38 ******/
CREATE NONCLUSTERED INDEX [IND_t_phone_address_no] ON [dbo].[T_PHONE]
(
[address_no] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
/****** Object: Index [IND_t_phone_customer_no] Script Date: 03/25/2009 15:41:43 ******/
CREATE CLUSTERED INDEX [IND_t_phone_customer_no] ON [dbo].[T_PHONE]
[customer_no] ASC
/****** Object: Index [IND_t_phone_phone] Script Date: 03/25/2009 15:41:52 ******/
CREATE NONCLUSTERED INDEX [IND_t_phone_phone] ON [dbo].[T_PHONE]
[phone] ASC
/****** Object: Index [PK_T_PHONE_1__21] Script Date: 03/25/2009 15:42:03 ******/
ALTER TABLE [dbo].[T_PHONE] ADD CONSTRAINT [PK_T_PHONE_1__21] PRIMARY KEY NONCLUSTERED
[phone_no] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]