Hi Puneet,
Schema :
[cid:[email protected]] Primary Key
[cid:[email protected]]
Foreign Keys
Cusromers_1
Column_Name Type_name
PK Varchar
C_Id Varchar
Address_1
Column_Name Type_name
PK Varchar
A_Id Varchar
A_C_Id Varchar
Orders_1
Column_Name Type_name
PK Varchar
O_Id Varchar
O_C_Id Varchar
Order_Details_1
Column_Name Type_name
PK Varchar
O_D_Id Varchar
O_Id Varchar
Query :
select /*+ NO_STAR_JOIN */ c."C_Name",a."City",a."State" from
"Address_1" WITH(NOLOCK) as a
inner join "Customers_1" WITH(NOLOCK) as c on a."A_C_Id" = c."C_Id"
inner join "Orders_1" WITH(NOLOCK) as o on a."A_C_Id" = o."O_C_Id"
inner join "Order_Details_1" WITH(NOLOCK) as od on od."O_Id" = o."O_Id"
inner join "Payterms_1" WITH(NOLOCK) as p on p."Payt_Id" = o."O_Pay_Terms"
inner join "Shipterms_1" WITH(NOLOCK) as s on s."Shipt_Id" = o."O_Ship_Terms"
where c."C_Id" = '150'
please let us know if we can ensure NO LOCK functionality .
Thanks,
Siddharth
From: Puneet Kumar Ojha [mailto:[email protected]]
Sent: Thursday, December 04, 2014 9:33 PM
To: [email protected]
Subject: RE: No Lock hint in phoenix
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.
Thanks
Puneet.
From: Siddharth Ubale [mailto:[email protected]]
Sent: Thursday, December 04, 2014 7:28 PM
To: [email protected]<mailto:[email protected]>
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 :
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,
image001.emz
Description: image001.emz
image003.emz
Description: image003.emz
