JOIN INDEX USAGE

Database
Enthusiast

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