OraFAQ Forum: Performance Tuning » SQL Logic (merged by CM)

Home » RDBMS Server » Performance Tuning » SQL Logic (merged by CM) (Oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Logic (merged by CM) [message #451388]

Wed, 14 April 2010 05:39

kkmohan1
Messages: 1
Registered: April 2010

Junior Member

Hi I am trying to implement this logic in my SQL in where condition

( (EDW.V_SEC.CUST_NUMBER = EDW.D_CUSTOMER.CUST_NUMBER OR EDW.V_SEC.CUST_NUMBER='ALL') AND
(EDW.V_SEC.BILL_GROUP = EDW.D_CUSTOMER.BILL_GROUP OR EDW.V_SEC.BILL_GROUP='AL' ) AND
(EDW.V_SEC.DIST_NUMBER = EDW.D_CUSTOMER.DIST_NUMBER OR EDW.V_SEC.DIST_NUMBER='A

but when i am using ORconiditon it taking lot of time for getting data.

EDW.V_SEC is a security table which contains all customer numbers, bill groups, district number.

Please help me in tuning this.

Thanks
Mohan

Report message to a moderator

Re: SQL Logic (merged by CM) [message #451391 is a reply to message #451388]

Wed, 14 April 2010 05:47

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

http://www.orafaq.com/forum/mv/msg/84315/433888/129190/#msg_433888
Post complete query and explain plan if you want us to take a look.

Report message to a moderator

Previous Topic:	Using 9i stored outlines by 11g SPM
Next Topic:	same query different explain plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 12 09:05:16 CDT 2024