Hi , Can somebody help me to optimize this query :
select /*+ NO_STAR_JOIN */ * from "Address" as a inner join "Customers" as c on a."A_C_Id"=c."C_Id" inner join "Orders" as o on o."O_C_Id"=a."A_C_Id" inner join "Order_Details" as od on od."O_Id"=o."O_Id" inner join "Payterms" as p on p."Payt_Id" =o."O_Pay_Terms" inner join "Shipterms" as s on s."Shipt_Id" =o."O_Ship_Terms" where c."C_Id" = '45954' ; we are getting response time of 3sec on this query … How do we possibly get it down to 500mS. Each table contains 100000 rows other than Order_details which contains 400000 rows. Thanks, Siddharth Ubale, Synchronized Communications #43, Velankani Tech Park, Block No. II, 3rd Floor, Electronic City Phase I, Bangalore – 560 100 Tel : +91 80 3202 4060 Web: www.syncoms.com<http://www.syncoms.com/> [LogoNEWmohLARGE] London|Bangalore|Orlando we innovate, plan, execute, and transform the business
