Delay in select statement multiple order by

[dtiwari]

I have a select sql statement with 2 order by parameters.It works in 0 sec in query analyzer and works fast with just 1 order by parameter when used with Java. However if I have 2 order by parameters it is reallllly slow...I don't know why this is happening ..any idea ??

I am using Jboss 3.2.3, Sql server.....

Any idea anyone ?

[adrian.brock]

Moderated: This is not the MSSQL JDBC Driver support forum