Will Find object using child property lead to full table scan ??

Data Service
1

Hi -

I have table ‘Customer’.
This table has related 1-to-1 child table as ‘MembershipCard’.
‘MembershipCard’ has indexed unique column as ‘Id’.

Now, if I do find on ‘Customer’ table with where clause as - MembershipCard.Id = ‘xyz’ - will this result into a full table scan on ‘Customer’ table ?

Is there any way to optimize the same ?

Thanks.

2

Hi Aditya,
Backendless indexing is just a wrapper over Maria DB Indexing, I would recommend you to forward your question to Maria DB team.
Anyway, do you experience any perfomance issues?
Regards, Artur