phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Puneet Kumar Ojha <>
Subject RE: No Lock hint in phoenix
Date Thu, 04 Dec 2014 16:03:14 GMT
Hi Siddharth,

Can you send all the queries which may run on the tables.

Also if you can send the schema of the tables created on Phoenix, I may help you out.


From: Siddharth Ubale []
Sent: Thursday, December 04, 2014 7:28 PM
Subject: No Lock hint in phoenix

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