phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Ubale <siddharth.ub...@syncoms.com>
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 :

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,

Mime
View raw message