Re: Simple left join query with abysmal performance.

[korinah]

I think it would be more faster if you change the sql stmt:

SELECT
A.MOV_ID,
A.MOV_Title,
A.MOV_YearOfProduction,
A.MOV_Length,
A.DIR_ID,
A.PRO_ID,
A.STU_ID,
A.SER_ID,
A.MOV_IsOnline,
A.MOV_Comment,
A.MOV_Cover_F,
A.MOV_Cover_B,
A.MOV_BuyPrice,
A.MOV_Movie_Type
FROM MOV_Movies as A INNER JOIN LNK_ACT_MOV as B
ON A.MOV_ID = B.MOV_ID;