I am using access 2013 frontend and backend SQL server. I have below this query. I am running this query via pass through query in Access but because of millions of records it runs continuly or freez but dost not give me output.
Is there any best way to run this query fast. I have vitrual tables and no index on it.
What is the best procedre to run this query fast. Kindly help.
SELECT PODETAIL.PODATE, PODETAIL.PONBR, PODETAIL.ITEM, PODETAIL.VDRNBR, PODETAIL.WERKS, PODETAIL.MENGE, PODETAIL.MEINS, PODETAIL.BPRME, PODETAIL.GEWEI, PODETAIL.VOLUM, PODETAIL.VOL, PODETAIL.LTSNR, POHEADER.VDRNBR FROM PODETAIL
INNER JOIN POHEADER
ON
(PODETAIL.PONBR = POHEADER.PONBR)
WHERE POHEADER.VDRNBR = '000250000' AND POHEADER.PODATE BETWEEN 20140101 AND 20151231
everytime i run it it freez my computer.
Is there any best way to run this query fast. I have vitrual tables and no index on it.
What is the best procedre to run this query fast. Kindly help.
SELECT PODETAIL.PODATE, PODETAIL.PONBR, PODETAIL.ITEM, PODETAIL.VDRNBR, PODETAIL.WERKS, PODETAIL.MENGE, PODETAIL.MEINS, PODETAIL.BPRME, PODETAIL.GEWEI, PODETAIL.VOLUM, PODETAIL.VOL, PODETAIL.LTSNR, POHEADER.VDRNBR FROM PODETAIL
INNER JOIN POHEADER
ON
(PODETAIL.PONBR = POHEADER.PONBR)
WHERE POHEADER.VDRNBR = '000250000' AND POHEADER.PODATE BETWEEN 20140101 AND 20151231
everytime i run it it freez my computer.
Last edited: