My joins seem too slow!

Hi,

I am plodding through our sql statements to try and optimise them but I worry im chasing my tail a bit.  The following is a simple example I would like a sanity check on :-

select * from BOOKS
INNER JOIN ticketheaders ON
TICKETHEADERS.ticketnumber = BOOKS.ticketnumber
INNER JOIN results on
results.ticketnumber = books.ticketnumber and
results.userid = books.userid and
results.bookname = books.bookname
where BOOKS.userid = 'NEIL' and BOOKS.bookname = 'all desks'

Books and Results have approx 258,000 records and TicketHeaders has approx 57,000.

The result set should consists of all the ticketheaders so it should be around the 57,000 mark.

When I run the query it takes approx. 7 seconds to execute (which I think is too long - RAID 5 with 5 drives, 2gb RAM, dial xeon procs) with the following text plan :-

  |--Merge Join(Inner Join, MERGE:([Results].[TicketNumber])=([TicketHeaders].[TicketNumber]), RESIDUAL:([TicketHeaders].[TicketNumber]=[Results].[TicketNumber]))
       |--Merge Join(Inner Join, MERGE:([Books].[TicketNumber])=([Results].[TicketNumber]), RESIDUAL:([Books].[TicketNumber]=[Results].[TicketNumber]))
       |    |--Clustered Index Seek(OBJECT:([Reality].[dbo].[Books].[PK_Books]), SEEK:([Books].[UserID]='NEIL' AND [Books].[BookName]='all desks') ORDERED FORWARD)
       |    |--Clustered Index Seek(OBJECT:([Reality].[dbo].[Results].[PK_Results]), SEEK:([Results].[UserID]='NEIL' AND [Results].[BookName]='all desks') ORDERED FORWARD)
       |--Clustered Index Scan(OBJECT:([Reality].[dbo].[TicketHeaders].[PK_TicketHeaders]), ORDERED FORWARD)

I just want some confirmation on where you would put the indexes and what you would expect the plan to show (ie. seek instead of scan etc).  I really thought all my stuff was optimised pretty well but I just want it verified on this simple example.

Many thanks.

James.