[P2P] Possible p2p sync slow regression

[ekigamba]

Describe the Issue

The updates on Android FHIR SDK made here delete an index that was added in this PR. The purpose of the index is to speed up p2p sync

We need to manually test this out on any SQLite browser with the latest DB containing these changes to confirm if the new index resolves this issue or we will need to add the index_from index.

The query used in p2p that is affected is

SELECT a.serializedResource
FROM ResourceEntity a
LEFT JOIN DateIndexEntity b
ON a.resourceType = b.resourceType AND a.resourceUuid = b.resourceUuid 
LEFT JOIN DateTimeIndexEntity c
ON a.resourceType = c.resourceType AND a.resourceUuid = c.resourceUuid
WHERE a.resourceUuid IN (
SELECT resourceUuid FROM DateTimeIndexEntity
WHERE resourceType = 'Task' AND index_name = '_lastUpdated' AND index_to >= '0'
)
AND (b.index_name = '_lastUpdated' OR c.index_name = '_lastUpdated')
ORDER BY b.index_from ASC, c.index_from ASC, a.id ASC
LIMIT 25 OFFSET 0

More details about the issue can be found here. The latest DB changes are available on v0.2.4-opensrp or possibly on main