Pass Throug Query error

[adnancanada]

I have very large tables (back hand SQL SEVER). I have this code running fine.



I have PO header table is called pkko and I have PO details is called tkko, vdrnbr is coming from tkko.

Select PO, POdate, Itemdes, vdrnbr from pkko
INNER JOIN tkko
ON
pkko.po = tkko.po

when I run above pass through query it runs fine. When I run below query using condition then it give me error msg of "Timeout"

Select PO, POdate, Itemdes, vdrnbr from pkko
INNER JOIN tkko
ON
pkko.po = tkko.po
where vdr = '1230000'

why?

[ItsMe]

I am going to guess the Connection TimeOut property of your pass through is shorter than the time required to apply the WHERE clause. Is the column you are applying the criteria to really Text?

Maybe you can increase the value of your TimeOut. IIRC, if you set the value to 0 it will not have a timeout.

Another option might be to create a View and index your vdr column as indexed using Included
https://msdn.microsoft.com/en-us/library/ms190806.aspx