Posted by joshsackett on 10/22/45 11:34

I realized that it had to do with the UNION command. It was performing
a poor search in the first place and when the UNION ran it had to
perform a sort.

Thanks for the help.

• Next in forum: Fuego, Tomcat, JDBC & SQL Server 2000
• Prev in forum: Re: Nested Nodes in XML from a table
• Thread view: Re: Indexes being improperly used when selecting data through a view

[Reply to this message]