Hi Siddharth, Could you please run "explain <your_query>" and post the query plan you got?
Thanks, Maryann On Tue, Dec 16, 2014 at 9:31 AM, Siddharth Ubale < [email protected]> wrote: > > Just a correction; > > > > Order_details :400000 > > Orders :200000 > > Rest of the tables 100000 > > > > Thanks, > > Siddharth > > > > *From:* Siddharth Ubale > *Sent:* Tuesday, December 16, 2014 8:01 PM > *To:* '[email protected]' > *Subject:* Join Queries > > > > 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 <%2B91%2080%203202%204060>* > > *Web:* *www.syncoms.com* <http://www.syncoms.com/> > > *[image: LogoNEWmohLARGE]* > > *London*|*Bangalore*|*Orlando* > > > > *we innovate, plan, execute, and transform the business* > > > -- Thanks, Maryann
