No Lock hint in phoenix

[Siddharth Ubale]

Hi ,

We are running queries in Phoenix and getting a very high latency. Since we are 
using Phoenix more on reporting tables and not on transactional tables, we were 
wondering whether it is possible to run a query using the “ with (NO LOCK) “ 
hint  so that we can increase the response times for queries.

A sample SQL query like this is what we aim to run using Phoenix :

SELECT
    first_name,
    last_name,
FROM dbo.person p WITH (NOLOCK)
JOIN dbo.employee e WITH (NOLOCK)
    ON e.person_id = p.person_id
WHERE p.person_id = 1;

Is this possible to achieve in Phoenix?

Thanks,

Siddharth Ubale,