We are facing a Time out problem while executing a query
with larger data fetch from our VB dll. The query used is
as follows


SELECT DISTINCT
TOP 15000 R.XTABLE_ID AS ID,
R.YTABLE_ID, R.Acctno,
S.ACP_ID, R.Sett
FROM YTABLE S INNER JOIN
XTABLE R ON S.YTABLE_ID =
R.YTABLE_ID AND R.Pdt >= '7/14/02' AND R.PDt <= '7/14/03'
AND


R.Acctno IN (9999,
479507390, 9000900395, 459400390,
429709390, 420900390, 490300390, 90395, 407696390,
355600390, 278900390, 268540395, 236598395,
8888859395, 8888850395, 8888827395,
8888800395, 298500390, 999902390, 967200390, 938370395,
933800390, 6000000395, 928800390,
923654395, 922209390, 86800390,
79000390, 3336662395, 40800390, 3039977395, 32659395,
98200390, 90200395, 90200390, 90000390,
9009000395, 999999395)

The error is
[Microsoft][ODBC SQL Server Driver] Timeout Expired

WE changed the commandtimeout and the connection timeout
property from application ,but we are getting the same
error.

We have non clustered index for all fields in the where
clause.

Kindly suggest us