1 Reply Latest reply on Feb 3, 2005 12:49 AM by Adrian Brock

    Delay in select statement multiple order by

    dhirendra tiwari Newbie

      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 ?