OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Query optimize (oracle, 10.2.0.2, AIX5.3)

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

Query optimize [message #556265]

Fri, 01 June 2012 05:37

soft_doctor
Messages: 33
Registered: May 2010

Member

Hi Leaders,

Please help me in the below scenario. I want to optimize the below query as using not equal ( != ) will reduce the performance.

select e1.rowid from emp e1, emp e2 
where e1.attrib in (7, 10)
and e1.attrib != e2.attrib 
and e1.type = e2.type 
and e1.status = 0)

Report message to a moderator

Re: Query optimize [message #556266 is a reply to message #556265]

Fri, 01 June 2012 05:39

soft_doctor
Messages: 33
Registered: May 2010

Member

Requesting you to please suggest as it is bit urgent!!!!

Report message to a moderator

Re: Query optimize [message #556278 is a reply to message #556266]

Fri, 01 June 2012 06:15

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing is urgent on forum but YOU to follow OraFAQ Forum Guide and post what is requested.

Please do it, it is urgent!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Regards
Michel

Report message to a moderator

Previous Topic:	Verify statspack
Next Topic:	Why delete a where rowid=:1 go to index?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 09 02:02:34 CDT 2026