All Forums Database
LUCAS 56 posts Joined 06/09
21 Oct 2015
JOIN INDEX USAGE

Hi,
User on site ask for locking a Join Index (single table T1)  in access in  a request for UPDATing T2 from SELECT from T2 JOIN base table T1 ... , does it make sense ?
AFAIK a join Index is used - or not - by the optimizer and there is no place for direct SELECT on it , nor for LOCKING commands.
Explain does not show any error, nevertheless i have a doubt ...
Pierre

You must sign in to leave a comment.