phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Ubale <>
Subject No Lock hint in phoenix
Date Thu, 04 Dec 2014 13:58:26 GMT
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 :

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?


Siddharth Ubale,

View raw message