In my JRun/SQLServer environment, the first query takes much longer than any subsequent queries. Something close to a minute vs. 2 seconds! The greater the number of records in the queried table, the longer the wait. The number of records returned does not seem to affect it much. Also, when I run the same query in Query Analyzer, it runs quickly even the first time. I am using Sun ODBC JDBC Bridge, but also tried the Data Direct driver and did not make a difference. The table is indexed. Not sure what else to try. Any help is appreciated.