Hi,
Try making the CompanyName a Clustered index. By doing this all queries will come out in Company Name Order. You dont need Order By Clause. You can only have one Clustered index per Table. I had the Same problem with a Million record Book Table. The LIKE% is not very Efficient either.
Hope this Helps
Fred
Fred Besterwitch, MCP
The harder you work. The luckier you get.
