do we need to add index on :property_id? from what i remember foreign keys are automatically index. But not sure. just double check it