Hi Siddharth, Phoenix does no locking, so I'm not sure what functionality you're after wrt the hint you're proposing. Have you tried adding secondary indexes on your foreign key columns? Also, join order is important: you'd want to join from the biggest (on the lefthand side) to the smallest (on the righthand side) in terms of rows returned from each table. Thanks, James
On Fri, Dec 5, 2014 at 6:24 AM, Siddharth Ubale <[email protected] > wrote: > Hi Puneet, > > > > > > Schema : > > > > Primary Key > > > > 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] > <[email protected]>] > *Sent:* Thursday, December 04, 2014 7:28 PM > *To:* [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, > > >
